pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Queries sometimes take 1000 times the normal time
Date: Thu, 28 Aug 2003 14:40:03 +0530
Message-ID: <3F4E1443.7646.12E864@localhost> (raw)
In-Reply-To: <MKEGJINFADFODDNOKEJCEECAEAAA.rg@tcslon.com>
References: <bijdiq$tor$1@harrier.cohaesio.com>

On 28 Aug 2003 at 10:02, Russell Garrett wrote:

> 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...


Bye
 Shridhar

--
Abstainer, n.:	A weak person who yields to the temptation of denying himself a	
pleasure.		-- Ambrose Bierce, "The Devil's Dictionary"




view thread (15+ messages)  latest in thread

Message-ID: <3F4E1443.7646.12E864@localhost>
Permalink:  ../3F4E1443.7646.12E864@localhost/
Also on:    postgresql.org/message-id/3F4E1443.7646.12E864@localhost

 · 

reply

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: shridhar_daithankar@persistent.co.in
  Subject: Re: Queries sometimes take 1000 times the normal time
  In-Reply-To: <3F4E1443.7646.12E864@localhost>
  References: <bijdiq$tor$1@harrier.cohaesio.com> <3F4E1443.7646.12E864@localhost>

* 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