On Thu, 2007-07-26 at 11:27 -0400, Jignesh K. Shah wrote:
> However at 900 Users where the big drop in throughput occurs:
> It gives a different top "consumer" of time:
TransactionIdGetStatus doesn't directly call SimpleLruReadPage().
Presumably the compiler has been rearranging things??
Looks like you're out of clog buffers. It seems like the clog buffers
aren't big enough to hold clog pages for long enough and the SELECT FOR
SHARE processing is leaving lots of additional read locks that are
increasing the number of clog requests for older xids.
Try the enclosed patch.
In response to
pgsql-performance by date
|Next:||From: Brandon Shalton||Date: 2007-07-26 16:18:55|
|Subject: disk filling up|
|Previous:||From: Tom Lane||Date: 2007-07-26 15:42:48|
|Subject: Re: User concurrency thresholding: where do I look? |