Re: [GENERAL] tuning postgresql writes to disk

2011-02-09 Thread Vick Khera
On Mon, Feb 7, 2011 at 7:43 PM, Vinubalaji Gopal wrote: > 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? > By definition, your application has to be able to

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 wrote: >> a

Re: [GENERAL] tuning postgresql writes to disk

2011-02-07 Thread Vick Khera
On Thu, Feb 3, 2011 at 7:08 PM, Vinubalaji Gopal wrote: > already does this.  I looked at the WAL parameters and the new async > commit  but not sure if I am looking at the right place. Say i have 10 > clients connecting and each client is inserting a record. I want to > You want the async commit

[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