Writing
pgstat 1.0 released
November 10, 2009
I added a couple of fixes to the code and released it as 1.0. We have been using it here at hi5 for some time w/o pro...
pg_reorg 1.0.4
June 25, 2009
At Hi5, we currently use pg_reorg1.0.3 in order to organize data in a clustered fashion. I posted previously about t...
Fusion-io SSD
May 27, 2009
I got the opportunity to test out some of the new Fusion-io Solid State ioDrive, and I thought I would post some resu...
pgstat 0.8beta released on PgFoundry
March 3, 2009
I moved the pgstat (previously named pgd) project to pgfoundry. Thank you to the folks over there approving the proje...
Cluster data, save cash
February 13, 2009
Since the economy is not exactly rocking these days, I suspect there are a lot of companies out there trying to save ...
Tuning for very large shared_buffers, using Veritas VxFS
December 12, 2008
The debate about the optimum shared_buffers size in PostgreSQL is clearly far from over. However, I have not seen any...
Graphing pgstat output
November 5, 2008
If you’re using the pgd pgstat utility I posted about previously, you can graph the output with very little effort us...
pgstat: a database utility like iostat
October 21, 2008
I needed a utility for capturing various data-points about a PostgreSQL database as I performed load tests. I copied ...