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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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