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
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!