Category Archives: PostgreSQL

pg_standby triggering unexpectedly

Posted on August 21, 2009 by Jon Smith

I have been having a problem with my redundant PostgreSQL setup over the last couple of weeks. I run two Postgres servers with a WAL Logging Warm Standby system using pg_standby from 8.3. When the master server is under heavy … Continue reading →

Posted in Linux, PostgreSQL, Sys Admin | Tagged , , , , | Leave a comment

PgFouine Automatic Report Setup with PostgreSQL & Logrotate

Posted on August 10, 2009 by Jon Smith

Monitoring & analysing your PostgreSQL server logs with PgFouine provides you with a way to see which queries are performing badly and need optimisation. It can also provide insight into busy periods and give some basic query stats such as … Continue reading →

Posted in PostgreSQL, Sys Admin | Tagged , , , , | Leave a comment

PostgreSQL Performance Tuning

Posted on June 24, 2009 by Jon Smith

I have had my head buried in Postgres tuning parameters today. There is so many different options to look at and no real definitive guidelines out there, and to make matters worse you can really impede performance with incorrect tuning parameters which is probably counter productive if your interested in tuning for performance :-) . Continue reading →

Posted in Linux, PostgreSQL | Tagged , , , | Leave a comment