From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andreas Joseph Krogh <andreak@officenet.no>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)
Date: Thu, 14 Apr 2005 19:20:10 -0400
Message-ID: <27433.1113520810@sss.pgh.pa.us> (raw)
In-Reply-To: <200504142157.03313.andreak@officenet.no>
References: <200504141838.14705.andreak@officenet.no>
<20050414190447.GE28198@dcc.uchile.cl>
<20050414190818.GD9027@phlogiston.dyndns.org>
<200504142157.03313.andreak@officenet.no>
Andreas Joseph Krogh <andreak@officenet.no> writes:
> On Thursday 14 April 2005 21:08, Andrew Sullivan wrote:
>> On Thu, Apr 14, 2005 at 03:04:47PM -0400, Alvaro Herrera wrote:
>>> It is a Postgres limitation as well. We _could_ make the server "really
>>> start the transaction" at the point the first query is issued instead of
>>> when the BEGIN is issued. In fact this problem would go away if we did
>>> that.
> I don't see this behaviour under 8.0.0, and it's presumably fixed:
> http://archives.postgresql.org/pgsql-jdbc/2004-06/msg00018.php
Well, recent JDBC drivers avoid the problem by postponing BEGIN,
but the issue still exists for some other client software. It's
something that we probably should fix on the server side.
IIRC the thing that was unresolved when we last discussed this
was what time now() should reflect --- when you issue BEGIN,
or when things really start to happen? To make the change fully
transparent we'd have to define now() as "when you issued BEGIN",
but there's a pretty good argument that now() should correspond
to the time of the transaction snapshot.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, andreak@officenet.no, ajs@crankycanuck.ca
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)
In-Reply-To: <27433.1113520810@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox