Tag Archives: PostgreSQL

Primary Keys for Slony-I

Posted on March 23, 2008 by kgorman

One of the prerequisites for Slony replication is to be sure that primary keys (or at least suitable columns) are defined for each table to be under replication. This is a simple example script for getting that data in postgresql. … Continue reading →

Posted in PostgreSQL | Tagged , | View Comments

Memory sizing for PostgreSQL

Posted on March 11, 2008 by kgorman

I needed to make an assessments of a linux server’s memory footprint consumed by postgresql, however, calculating the exact memory footprint of a postgresql database is not as straightforward as one might think. Since unix utilities like top, and ps … Continue reading →

Posted in Database Engineering, PostgreSQL | Tagged , | View Comments