[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] Adding new field to big table

2014-04-30 Thread RichmondDyes
Jeff I think adding the new table is the best way to handle this issue. From: Jeff Janes To: acanada , Cc: postgres performance list Date: 03/18/2014 02:05 AM Subject:Re: [PERFORM] Adding new field to big table Sent by:pgsql-performance-ow...@postgresql.org On