Writing
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.
July 30, 2008
After reading Allan Packers excellent blog entry ‘are proprietary databases doomed’ , a couple of additional thoughts...
Python script showing PostgreSQL objects in linux memory: pg_osmem.py
July 2, 2008
I got some email and comments about the code I used for my post; Mapping Linux memory for PostgreSQL using fincore so...
pg_standby lag monitoring
June 24, 2008
I have been using pg_standby quite a bit lately, and thus we needed some management tools around it. One simple thin...
Mapping Linux memory for PostgreSQL using fincore
June 18, 2008
PostgreSQL, more-so than other databases generally relies on OS file system cache to keep performance high. It is pre...
Incremental Commits in PostgreSQL
April 30, 2008
On large and/or busy databases it’s often not feasible to update an entire table at one time. For instance, if one ha...
int vs bigint
April 18, 2008
So which one is a better use of space given that an application uses 32bit integers? In PostgreSQL, the int column ta...
The next breed of DBA’s?
April 10, 2008
University of California, Berkeley and Carnegie Mellon University students now have what appears to be a first rate c...