X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1A247D1B947 for ; Thu, 28 Aug 2003 09:09:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 85708-06 for ; Thu, 28 Aug 2003 06:08:38 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id EFBE0D1DA4D for ; Thu, 28 Aug 2003 06:08:19 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h7S9Cb55010815 for ; Thu, 28 Aug 2003 14:42:37 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h7S9Cahi010802 for ; Thu, 28 Aug 2003 14:42:37 +0530 From: "Shridhar Daithankar" To: Date: Thu, 28 Aug 2003 14:40:03 +0530 MIME-Version: 1.0 Subject: Re: Queries sometimes take 1000 times the normal time Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F4E1443.7646.12E864@localhost> In-reply-to: References: X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/401 X-Sequence-Number: 3217 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"