Fusion-io SSD
Database Engineering PostgreSQL

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
PostgreSQL Python

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
Database Engineering PostgreSQL

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
Database Engineering PostgreSQL

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
PostgreSQL

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
PostgreSQL

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

Unique identifier for a database without connecting to the database?
PostgreSQL

Unique identifier for a database without connecting to the database?

September 16, 2008

In PostgreSQL, the working directory is a unique identifier for a database, and sometimes you want to use that workin...

Open source databases; scaling the application stack.
PostgreSQL

Open source databases; scaling the application stack.

July 30, 2008

After reading Allan Packers excellent blog entry ‘are proprietary databases doomed’ , a couple of additional thoughts...