X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 86020D1B947 for ; Wed, 5 Nov 2003 18:04:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84183-10 for ; Wed, 5 Nov 2003 14:04:23 -0400 (AST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 609B0D1B8DF for ; Wed, 5 Nov 2003 14:04:22 -0400 (AST) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1AHS10-0004Wp-00 for ; Wed, 05 Nov 2003 13:04:22 -0500 Received: by dba2 (Postfix, from userid 1019) id C8468C9B3; Wed, 5 Nov 2003 13:04:22 -0500 (EST) Date: Wed, 5 Nov 2003 13:04:22 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Response time Message-ID: <20031105180422.GF4506@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <1243.134.129.92.208.1067957379.squirrel@webmail.ndsu.nodak.edu> <1067976756.336.0.camel@tokyo> <1706.134.129.92.208.1068053722.squirrel@webmail.ndsu.nodak.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1706.134.129.92.208.1068053722.squirrel@webmail.ndsu.nodak.edu> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/17 X-Sequence-Number: 4577 On Wed, Nov 05, 2003 at 11:35:22AM -0600, radha.manohar@ndsu.nodak.edu wrote: > The \timing psql command gives different time for the same query executed > repeatedly. Why do you believe that the same query will always take the same time to execute? A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110