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

From Anders K. Pedersen
Subject Re: Queries sometimes take 1000 times the normal time
Date
Msg-id bim7v8$dbs$1@harrier.cohaesio.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
scott.marlowe wrote:
> 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.

According to vmstat it doesn't swap near the spikes, so I don't think
this is the problem. I posted a vmstat sample in another reply, where
you can see an example of what happens.

Regards,
Anders K. Pedersen


pgsql-performance by date:

Previous
From: Ken Geis
Date:
Subject: bad estimates / non-scanning aggregates
Next
From: Bill Moran
Date:
Subject: Taking another shot at the PostgreSQL/filesystem benchmarks