PostgreSQL 10 Beta

When: 6-8pm Thursday July 20, 2017
Where: iovation
Who: Josh Berkus
What: PostgreSQL 10 Beta

 

PostgreSQL 10 is now out in beta. We called it 10 because this release is going to blow your socks off. Josh Berkus will demonstrate several of the new features in this version, including built-in logical replication, native partitioning, additional query parallelism, JSON full-text search, and more. He’ll also explain some of the issues you’re likely to encounter upgrading to Version X.

Josh Berkus recently retired from the PostgreSQL Core Team and is currently working for Redhat as the Project Atomic Community Lead.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our meeting will be held at iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

PDXPUG: June meeting

When: 6-8pm Thursday June 15, 2017
Where: iovation
Who: Kevin Jernigan, AWS
What: Amazon Aurora (PostgreSQL)

In 2014, AWS announced Amazon Aurora – a cloud-native, MySQL-compatible relational database. Features include fault-tolerant, self-healing storage that allows customers to scale from 10 GB all the way up to 64 TB without pre-provisioning. Aurora makes six copies of data across three Availability Zones and backs it up to Amazon Simple Storage Service (S3) without impacting performance or availability. Customers can create up to 15 low-latency read replicas that draw from common storage.

In response to repeated customer requests for the same capabilities for PostgreSQL, AWS announced the Amazon Aurora PostgreSQL-compatible edition in late 2016.

In this talk we’ll cover what makes Aurora (PostgreSQL) different from PostgreSQL, as well as what remains the same. We’ll discuss compatibility, scalability and performance. Please bring your scenarios, questions and requests!


Kevin Jernigan is a Senior Product Manager in the Amazon Relational Database Services (RDS) team. His deep database engine experience spans Oracle, Ingres, Informix, DB2, and PostgreSQL. He lives in San Francisco, and when not working on database engines loves to play squash and spend time with his wife and kids.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our meeting will be held at iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

See you there!

PDXPUG – May meeting

When: 6-8:30pm Thursday May 18, 2017
Where: Oregon Convention Center – Expo Hall
Who: YOU
What: Meet & Greet

Note this meeting is not at our usual location!

PDXPUG is hosting the Postgres booth at PyCon (https://us.pycon.org/2017/). Instead of our regular meeting, stop by the booth to say hi to PDXPUG folks and PyCon attendees and have some drinks & snacks.

No registration is required to attend the reception, just come on out! https://us.pycon.org/2017/events/opening-reception/

See you there!

PDXPUG: April meeting

When: 6-8pm Thursday April 20, 2017
Where: iovation
Who: Josh Berkus
What: 9.6 Features

PostgreSQL 9.6 has been out for six months … how many of you have migrated to it? Well, you might decide to stop putting off that upgrade once you learn about a few of the features you might have missed reading about. In this all-demo presentation, Josh Berkus will show off a bunch of 9.6’s key features, including:

– parallel query
– sync replication improvements
– FDW query push-down
– crosstabs
– full-text phrase search
– pgAdmin4

Yes, Postgres 10 will be way cool, but that’s no reason to put off
deploying 9.6 now.

Josh Berkus recently retired from the PostgreSQL Core Team and is currently working for Redhat as the Project Atomic Community Lead.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our meeting will be held at iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

See you there!

PDXPUG – March meeting

When: 6-8pm Thursday March 16, 2017
Where: iovation
Who: Grant Holly
What: Intro to Postgres

This month, Grant’s going to give a talk best described as “Getting started with Postgresql for the uninitiated and bitter veterans”.

Grant Holly is a Service Reliability Engineer at iovation, where he works with a lot of different database systems.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our meeting will be held at iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

See you there!

PDXPUG – February meeting

When: 6-8pm Thursday Feb 16, 2017
Where: iovation
Who: Darrell Fuhriman
What: Just enough PostGIS: a brief intro to spatial data in Postgres

In this quick overview, Darrell will cover the spatial data model, data manipulation, spatial joins, and do some basic analysis.

Darrell has been active in the local Open Source Geospatial community for years, most exhaustingly as Chair of FOSS4G 2014, the world’s largest Open Source Geospatial conference. He also teaches Spatial Database Design in the Geography Department at Portland State University, and supplements his adjunct instructor income as VP of System Engineering at Renew Financial — a clean energy financing startup.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our meeting will be held at iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

See you there!

PDXPUG – January meeting

When: 6-8pm Thursday Jan 19, 2017
Where: iovation
Who: Mark Wong
What: pglogical

Mark Wong will give an overview of pglogical, the latest replication option for Postgres. It’s a lower-impact option than trigger-based replication, and features include the ability to replicate only the databases and tables you choose from a cluster. Part of the talk will cover use cases and future development plans.

Find out more here: https://2ndquadrant.com/en/resources/pglogical/

Mark leads the 2ndQuadrant performance practice as a Performance Consultant for English Speaking Territories, based out of Oregon in the
USA.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our meeting will be held at iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

See you there!