Postgres Pro
Downloads
Home   >   mailing lists

Re: User concurrency thresholding: where do I look? - Mailing list pgsql-performance

From Tom Lane
Subject Re: User concurrency thresholding: where do I look?
Date
Msg-id 12002.1184955831@sss.pgh.pa.us
Whole thread Raw
In response to Re: User concurrency thresholding: where do I look?  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Responses Re: User concurrency thresholding: where do I look?
List pgsql-performance
Tree view 
"Jignesh K. Shah" <J.K.Shah@Sun.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

pgsql-performance by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: Re: User concurrency thresholding: where do I look?
Next
From: Jim Nasby
Date:
Subject: Re: 8.2 -> 8.3 performance numbers