November 15, 2011 · 6:30 PM
This location is shown only to members
This month we welcome back Greg Smith, Baltimore native and author of PostgreSQL 9.0 High Performance, to speak about "Managing High Volume Writes with Postgres"
Greg will be talking about:
PostgreSQL has worked well for many OLTP style application, where a number of clients are writing heavily to the database throughout the day. But if you combine heavy write volume with archiving, eventually you'll start approaching a data warehouse sized database, with terabytes of data. Designing and tuning PostgreSQL for a combination of heavy incoming data and a large archive size requires some specialized knowledge, from how the database cleans up after old data to how partitioning can be used for this purpose.
Topic covered will include:
-Basic database tuning for high write volume
-Monitoring buffer cache throughput
-Issues with empty cache performance
-Adjusting VACUUM cleanup
-Partitioning for time series data
-Hardware for write-heavy database workloads
-Write scaling with Skytools
For those of you who already have his book, you may want to bring it along. I've seen him sign a copy or 2.