"Jerry Champlin" <jchamplin(at)absolute-performance(dot)com> writes:
> We have synchronous_commit turned off, commit siblings set to 5,
> commit_delay set to 50,000. With synchronous_commit off does it make
> any sense to be grouping commits?
No. In fact commit_delay is a total no-op in that mode. If it were
doing anything I think you'd have found that to be a counterproductively
large setting ...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: david||Date: 2008-08-27 21:45:47|
|Subject: Re: select on 22 GB table causes "An I/O error occured
while sending to the backend." exception|
|Previous:||From: Alvaro Herrera||Date: 2008-08-27 20:32:34|
|Subject: Re: Is there a way to SubPartition?|