Re: [GENERAL] tuning postgresql writes to disk

2011-02-07 Thread Vinubalaji Gopal
Thank you. I will try to run some performance tests using the async commit option. Is there an easy way to find the lost transactions or does it have to be handled by the application? On Mon, Feb 7, 2011 at 6:23 AM, Vick Khera wrote: > On Thu, Feb 3, 2011 at 7:08 PM, Vinubalaji Gopal wr

[GENERAL] tuning postgresql writes to disk

2011-02-03 Thread Vinubalaji Gopal
Hi,   I was wondering if Postgresql can be tuned such that it writes to disk every n seconds or until the buffer reaches a certain threshold to tune the performance . This is a special case where the application wouldn't care if there is a data loss of 1 seconds or less. I would be interested  to k