X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8F2ABD1B9B2 for ; Fri, 22 Aug 2003 03:37:43 -0300 (ADT) 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 13862-09 for ; Fri, 22 Aug 2003 03:37:12 -0300 (ADT) Received: from frmug.org (frmug-gw.frmug.org [193.56.58.252]) by svr1.postgresql.org (Postfix) with ESMTP id 708E0D1BA65 for ; Fri, 22 Aug 2003 03:37:10 -0300 (ADT) Received: from frmug.org (localhost [127.0.0.1]) by frmug.org (8.12.9/8.11.3/frmug-2.7/nospam) with ESMTP id h7M6b9g2071497 (using TLSv1/SSLv3 with cipher DHE-RSA-AES256-SHA (256 bits) verified NO) for ; Fri, 22 Aug 2003 08:37:10 +0200 (CEST) (envelope-from pgsql-sql@phoe.frmug.org) Received: (from uucp@localhost) by frmug.org (8.12.9/8.12.9/Submit) with UUCP id h7M6b90Y071496 for pgsql-sql@postgresql.org; Fri, 22 Aug 2003 08:37:09 +0200 (CEST) Received: (from elrond@localhost) by memo.frmug.org (8.11.6/8.11.6) id h7M6WW482253 for pgsql-sql@postgresql.org; Fri, 22 Aug 2003 08:32:32 +0200 (CEST) (envelope-from pgsql-sql@phoe.frmug.org) X-Authentication-Warning: memo.frmug.org: elrond set sender to pgsql-sql@phoe.frmug.org using -f Date: Fri, 22 Aug 2003 08:32:32 +0200 From: Bertrand Petit To: pgsql-sql@postgresql.org Subject: Re: "SELECT IN" Still Broken in 7.4b Message-ID: <20030822083232.C81672@memo.frmug.org> Mail-Followup-To: pgsql-sql@postgresql.org References: <18608.1061411539@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <18608.1061411539@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Wed, Aug 20, 2003 at 04:32:19PM -0400 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/266 X-Sequence-Number: 14882 On Wed, Aug 20, 2003 at 04:32:19PM -0400, Tom Lane wrote: > > against actual elapsed time (cf psql's \timing option) would tell. What is measured by the \timing option? The figures reported are slightly larger than those loged when the log_duration parameter is true. => select count(*) from foo; count -------- 362921 (1 row) Time: 5500.88 ms while in syslog, the timing was "LOG: duration: 5.499783 sec". There is a difference of 1.097 ms. In both cases what is this duration? Real time or CPU time? -- %!PS 297.6 420.9 translate 90 rotate 0 setgray gsave 0 1 1{pop 0 180 moveto 100 180 170 100 170 -10 curveto 180 -9 180 -9 190 -10 curveto 190 100 100 180 0 180 curveto fill 180 rotate}for grestore/Bookman-LightItalic findfont 240 scalefont setfont -151.536392 -63.7998886 moveto (bp)show showpage