Skip site navigation (1) Skip section navigation (2)

Re: Queries sometimes take 1000 times the normal time

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Anders K(dot) Pedersen" <akp(at)cohaesio(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Queries sometimes take 1000 times the normal time
Date: 2003-08-28 20:39:11
Message-ID: Pine.LNX.4.33.0308281438120.4942-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: 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.


In response to

Responses

pgsql-performance by date

Next:From: Jan WieckDate: 2003-08-28 21:00:02
Subject: Re: Replication Ideas
Previous:From: scott.marloweDate: 2003-08-28 20:33:41
Subject: Re: The results of my PostgreSQL/filesystem performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group