"Jignesh K. Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM> writes:
> There are no hard failures reported anywhere. Log min durations does
> show that queries are now slowing down and taking longer.
> OS is not swapping and also eliminated IO by putting the whole database
> on /tmp
Hmm. Do you see any evidence of a context swap storm (ie, a drastic
increase in the context swaps/second reading reported by vmstat)?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Jim Nasby||Date: 2007-07-20 18:32:34|
|Subject: Re: [PERFORM] 8.2 -> 8.3 performance numbers|
|Previous:||From: Jignesh K. Shah||Date: 2007-07-20 18:18:05|
|Subject: Re: User concurrency thresholding: where do I look?|