[PERFORM] Checkpoints and slow queries

2014-04-30 Thread Elanchezhiyan Elango
*Problem description:* After a few days of running in my test environment, a query timed out (query timeout=4mins). Also in general the queries were taking a lot longer than expected. The workload in my database is a write intensive workload. And the writes happen in a burst every 5 minutes. There

Re: [PERFORM] Checkpoints and slow queries

2014-04-27 Thread Elanchezhiyan Elango
put on ext3 filesystem and having WAL on a different disk. I'll see if these can be changed. I cannot change these in the short term. On Sun, Apr 27, 2014 at 3:46 PM, Tomas Vondra wrote: > On 27.4.2014 23:01, Elanchezhiyan Elango wrote: > > (I am resending this question after wait

[PERFORM] Checkpoints and slow queries

2014-04-27 Thread Elanchezhiyan Elango
(I am resending this question after waiting for several hours because my previous mail got stalled probably because I didn't confirm my email address after subscribing. So resending the mail. Sorry if this is causing a double post.) *Problem description:* After a few days of running in my test env