Writing
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...
Python/cx_Oracle utility functions
March 31, 2008
I recently created some utility functions to startup, mount and stop Oracle via cx_Oracle and thought I would share t...
Primary Keys for Slony-I
March 23, 2008
One of the prerequisites for Slony replication is to be sure that primary keys (or at least suitable columns) are def...