Posts Tagged: PostgreSQL

Primary Keys for Slony-I

Posted by & filed under PostgreSQL.

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. This assumes that the intention is to replicate all of the public schema. SELECT tablename… Read more »

Memory sizing for PostgreSQL

Posted by & filed under Database Engineering, PostgreSQL.

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 tend to show some amount of shared memory usage in their tallies, they are next… Read more »