Re: Queries sometimes take 1000 times the normal time - Mailing list pgsql-performance

From scott.marlowe
Subject Re: Queries sometimes take 1000 times the normal time
Date
Msg-id Pine.LNX.4.33.0308281438120.4942-100000@css120.ihs.com
Whole thread Raw
In response to Re: Queries sometimes take 1000 times the normal time  ("Anders K. Pedersen" <akp@cohaesio.com>)
List pgsql-performance
Just to add to the clutch here, also check your bdflush settings (if
you're on linux) or equivalent (if you're not.)

Many times the swapping algo in linux can be quite bursty if you have it
set to move too many pages at a time during cleanup / flush.


pgsql-performance by date:

Previous
From: Michael Guerin
Date:
Subject: Re: Simple queries take forever to run
Next
From: Sean Chittenden
Date:
Subject: Re: The results of my PostgreSQL/filesystem performance tests