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!

Advertisements

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:
http://2ndquadrant.com/media/cms_page_media/59/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 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!