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 1EEE4D1C92F for ; Sat, 15 Nov 2003 20:21:25 +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 83894-09 for ; Sat, 15 Nov 2003 16:20:54 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 252F1D1C93C for ; Sat, 15 Nov 2003 16:20:53 -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 7D7A61EB0; Sat, 15 Nov 2003 15:20:45 -0500 (EST) To: Tom Lane Cc: Will LaShell , Hannu Krosing , Christopher Browne , pgsql-performance@postgresql.org Subject: Re: Help with count(*) From: Neil Conway In-Reply-To: <4987.1068842326@sss.pgh.pa.us> (Tom Lane's message of "Fri, 14 Nov 2003 15:38:46 -0500") References: <200311141251.38786.mallah@trade-india.com> <1068831807.2540.44.camel@fuji.krosing.net> <3FB52FA7.8060508@lashell.net> <4987.1068842326@sss.pgh.pa.us> Date: Sat, 15 Nov 2003 15:20:43 -0500 Message-ID: <87isllbcys.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/131 X-Sequence-Number: 4691 Tom Lane writes: > (I believe the previous discussion also agreed that we wanted to > postpone the freezing of now(), which currently also happens at > BEGIN rather than the first command after BEGIN.) That doesn't make sense to me: from a user's perspective, the "start of the transaction" is when the BEGIN is issued, regardless of any tricks we may play in the backend. Making now() return the time the current transaction started is reasonably logical; making now() return "the time when the first command after the BEGIN in the current transaction was issued" makes a lot less sense to me. -Neil