SFPUG August: two tools you can't live without

For August, help PostgreSQL Experts break in our new training center with two brief presentations by two speakers. The two back-to-back presentations start at 7pm. Food & drink sponsored by PostgreSQL Experts.

pg_reorg

first, Igor Polishchuk will present on pg_reorg:

This tool helps a lot with: - eliminating table bloat, which is even more than just defragmentation) - data clustering - removing large portion of a huge table's data ( for example for splitting partitions) Unfortunately, I noticed that many people are unfamiliar with this great though a little rudimentary tool.

pgBouncer and you

Josh Berkus will show you pgBouncer: what it is, what it does, and why you can't live without it. He'll go over how to configure it and some of the interesting tricks it can be used for.

Food and drink will be sponsored by PostgreSQL Experts Inc (http://pgexperts.com).

Streaming video of this session will be available on the August 9th SFPUG Streaming Page (http://thebuild.com/sfpug201108/)