Managing High Volume Writes with Postgres

  • 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

 

PS:

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. 

 

Join or login to comment.

8 went

Our Sponsors

People in this
Meetup are also in:

Imagine having a community behind you

Get started Learn more
Rafaël

We just grab a coffee and speak French. Some people have been coming every week for months... it creates a kind of warmth to the group.

Rafaël, started French Conversation Group

Start your Meetup today

Act now and get 50% off.
Until February 1.

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy