From: Russell Garrett <rg@tcslon.com>
To: pgsql-performance@postgresql.org
Subject: Re: Queries sometimes take 1000 times the normal time
Date: Thu, 28 Aug 2003 10:28:29 +0100
Message-ID: <MKEGJINFADFODDNOKEJCOECBEAAA.rg@tcslon.com> (raw)
In-Reply-To: <3F4E1443.7646.12E864@localhost>
>> The web site queries will jump up one or two orders of magnitude (I
>> have seen a normally 100ms query take in excess of 30 seconds) in
>> duration at seemingly random points. It's not always when the
>> transactions are committing, and it doesn't seem to be during
>> checkpointing either. The same thing happens with WAL switched off.
>> It appears to happen the first time the query runs after a while. If
>> I run the same query immediately afterwards, it will take the normal
>> amount of time.
>
> Looks like it got flushed out of every type of cache and IO scheduler
> could not deliver immediately because of other loads...
Yeah, I wasn't sure what (or how) Postgres caches. The db server does have
2Gb of memory, but then again the database amounts to more than 2Gb, so it's
fairly possible it's getting pushed out of cache. It's also fairly possible
that it's not tuned completely optimally. I wonder if FreeBSD/kernel 2.6
would perform better in such a situation...
Russ
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: rg@tcslon.com
Subject: Re: Queries sometimes take 1000 times the normal time
In-Reply-To: <MKEGJINFADFODDNOKEJCOECBEAAA.rg@tcslon.com>
References: <3F4E1443.7646.12E864@localhost> <MKEGJINFADFODDNOKEJCOECBEAAA.rg@tcslon.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox