Categories
Linux PostgreSQL Sys Admin

pg_standby triggering unexpectedly

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 load and generating a lot of WAL traffic the secondary server has been tripping and going active.

After checking all the logs and putting pg_standby in debug mode there was still no clue as to why this was happening.

Categories
PostgreSQL Sys Admin

PgFouine Automatic Report Setup with PostgreSQL & Logrotate

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 the number of INSERT, DELETE, UPDATE, and SELECT operations.

Categories
Linux PostgreSQL

PostgreSQL Performance Tuning

Well I have had my head buried in Postgres tuning parameters today. There are 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 :-).

I have read a lot of blog posts and articles today and will list the ones I found most helpful below.