PDXPUG Mar 21: Replication with Postgres

2024 Thursday Feb 15th Meeting 6:30pm:8:30pm

Location: American Red Cross

3131 N Vancouver Ave · Portland, OR

Speaker: Grant Holly

This presentation will cover replicating your data with Postgres with a focus on streaming and logical replication. We are going to look at how the different kinds of replication work. It will be whirlwind trip through the use-cases, advantages, and challenges with different kinds of replication.

If you are a Postgres veteran and can configure replication from memory: this talk is for you. If you are someone new to Postgres, or someone who is just curious about Postgres: this talk is for you too! I’m always open to questions.

Hi, it’s me again. I’m Grant. I’ve been working with Postgres in production since version 9.2. I’ve been a speaker and subject matter expert on Postgres. Along with Mark Wong, I co-lead the Portland Postgres User Group.

PDXPUG April 2023: Know Your Index part 2

2023 April 20th Meeting 6:30pm-8:30pm

Location:

PDX Code Guild
407 NE 12th Avenue, Portland, OR 97232
The parking lot is behind the building on Flanders.

Speaker: Grant Holly

We are going to continue our tour of indexes in Postgres. This time around we are going to look into the index data structures, and how they affect performance. We will cover B+Trees, hash tables, and inverted indexes as well as looking at the Brin and SP-Gist indexes.

Later we will talk about use cases for the different kinds of indices. And finally, we will settle the “indexes” vs “indices”!

This talk is for all experience levels. Bring your questions and stories. We are looking forward to seeing you there.

If you want to join us remotely, here is a zoom link: https://us06web.zoom.us/j/82183686272?pwd=ZTkvVVduQndJZVdSRHB2Q3lEbmhoQT09

PDXPUG March 2023: Know Your Index

2023 March 16th Meeting 6:30pm-8:30pm

Location:

PDX Code Guild
407 NE 12th Avenue, Portland, OR 97232
The parking lot is behind the building on Flanders..

Speaker: Grant Holly

Postgres has many different kinds of indices for different use cases. Let’s take a look at the different options that come with indexing your data. We will also look at index trade-offs because, as you know, there’s no free lunch.

This talk is for all experience levels. Bring your questions and stories. We are looking forward to seeing you there.

PDXPUG September meeting in 1 week

… ok, maybe a bit less than a week.

When: 6-8pm Thursday Sept 21, 2017
Where: iovation
Who: Mark Wong
What: Postgres BI Performeant & News From the Pg-XL Project

If you missed Postgres Open, here’s your chance to catch one of the talks!

Mark will share performance improvements in analytical / BI workloads in recent PostgreSQL releases, illustrated with results from multiple major versions, and also about what additional improvements might happen in the near future. He’ll will also discuss news from Postgres-XL, the distributed PostgreSQL fork, and how it compares to the current PostgreSQL in this area.

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!

PDXPUG: June meeting next week

When: 6-8pm Thursday June 18, 2015
Where: Iovation
Who: Mark Wong
What: Pg Performance

Come have a chat with our local performace expert, Mark Wong.

This presentation will take a look at the performance changes in the development version of PostgreSQL. A selection of features, some proposed and some already committed, are evaluated using synthetic open source workloads. One of the workloads used is the former OSDL’s Database Test 3 that consists of business oriented ad-hob queries with concurrent data modification.

—
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). Due to fire alarm testing at our regular location, we’ll be meeting in the main Board Room of the US Bancorp Tower, 111 SW 5th. (We’ll have signs up in the lobby to guide you.) 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!

See you there!

State of the Portland PostgreSQL Performance Pad

Wikipedia recently donated two Dell PowerEdge 2950s for the Pg QA Platform. Mark Wong & I have made a few trips out to the colo to get them racked up and online (with Chelnik‘s help, of course.)

We were quite surprised when we received the servers; Wikipedia included full rackmount kits, instructions, and cables, all in the original packaging. More than we expected, and much appreciated!

Unfortunately, after installing the OS, one of the PowerEdges had a spontaneous failure of its RAID controller. Troubleshooting continues, but at this time it looks like that box is destined to be a “parts car”. Naturally, one of the other servers took that as a cue to reject *its* raid controller. (Why does this happen?) That server was hooked up to the Powervaults, so we don’t have a NAS right now.

Once we get all this sorted out, we’ll be consolidating projects on to the remaining servers.

Thanks to Wikipedia for the new equipment, and to CMD for continuing to sponsor hosting at SpireTech.

PDXPUG: November meeting recap

We had a great meeting last week, with over 20 attendees turning out to hear Greg Smith get into some exciting details about VACUUM. Video will be posted once we filter out some feedback.

Slides are here:

Click to access ScalingMaint.pdf

His autovacuum cost estimator spreadsheet is here (and also linked from the .pdf above):
http://highperformancepostgres.com/pgopen-2012/

Thanks to Iovation for hosting and providing yummy sandwiches, and to Greg for flying all the way out here.

As usual, no meeting in December. As usual, go to the 6th Annual Winter Coders’ Social instead:
http://calagator.org/events/1250463028

We’ll start back up on January 17. John Melesky will be giving a newer version of his talk from PgOpen, PostgreSQL in the Cloud.

PDXPUG: November meeting reminder

Our November meeting is this week! Greg Smith will be talking about Scaling Database Maintenance.

See the original announcement for more details.

PDXPUG: November Meeting in three weeks

Sending the announcement out a bit early this month so you can get this on your calendar, because you don’t want to miss it. Greg Smith is visiting our fair city & will be speaking at our November meeting!

When: 7-9pm Thu Nov 15, 2012
Where: Iovation
Who: Greg Smith
What: Scaling Database Maintenance

When your database is small, the database’s autovacuum background daemon will keep up with the routine maintenance work that tables and indexes need. Once your database is larger though, and larger typically starts in the 100GB or 100M row range, the automatic maintenance as it’s tuned by default won’t be good enough.

This talk will introduce what VACUUM and autovacuum do. Some common manual settings and approaches for larger databases will be outlined. You’ll get a spreadsheet to help with tuning the tricky autovacuum settings. Finally, re-building indexes with minimal downtime will be outlined, emphasizing techniques introduced in PostgreSQL 9.1 that make that job easier.

Greg Smith is the Principal Consultant at 2ndQuadrant US and author of “PostgreSQL 9.0 High Performance”.

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!

Building security will close access to the floor at 7:30.

After-meeting beer location TBD. See you there!

PDXPUG: January Meeting

When: 7-9pm Thu January 19, 2012
Where: Iovation
Who: Tim Bruce
What: Database Trending

Tim started a new job earlier this year and was looking at how to gather some performance metrics to measure database performance over long periods. While these will change since he works in a very fluid environment, being able to see some differences over time will allow for some forecasting as well. Tim will start by showing some of the things he’s identified, and the code he has, to track these elements and then will lead a round-robin discussion of what other people may be doing to
capture their own metrics.

Tim Bruce has been working with computers for over 25 years doing Data Management, Programming, Systems Administration and Database Administration. Currently, Tim is the Database Administrator for Conducive Technology, the company behind FlightStats.

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!

Building security will close access to the floor at 7:30.

After-meeting beer location TBD. See you there!