Re: Is there a way to SubPartition?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jerry Champlin" <jchamplin(at)absolute-performance(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is there a way to SubPartition?
Date: 2008-08-27 20:54:03
Message-ID: 29791.1219870443@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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

Browse pgsql-performance by date

  From Date Subject
Next Message david 2008-08-27 21:45:47 Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Previous Message Alvaro Herrera 2008-08-27 20:32:34 Re: Is there a way to SubPartition?