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 7C0CDD1BB9A for ; Wed, 5 Nov 2003 17:40:58 +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 85177-01 for ; Wed, 5 Nov 2003 13:40:28 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 51429D1BB7B for ; Wed, 5 Nov 2003 13:40:27 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id 6AB381DF2; Wed, 5 Nov 2003 12:40:20 -0500 (EST) To: Cc: Subject: Re: Response time From: Neil Conway In-Reply-To: <1706.134.129.92.208.1068053722.squirrel@webmail.ndsu.nodak.edu> (radha manohar's message of "Wed, 5 Nov 2003 11:35:22 -0600 (CST)") 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> Date: Wed, 05 Nov 2003 12:40:18 -0500 Message-ID: <87ad7ar9x9.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/16 X-Sequence-Number: 4576 writes: > The \timing psql command gives different time for the same query executed > repeatedly. That's probably because executing the query repeatedly results in different execution times, as one would expect. \timing returns the "exact" query response time, nevertheless. -Neil