Re: row-attribute in EXPLAIN-output doesn't match count(*)

From: Carlos Moreno <moreno(at)mochima(dot)com>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-sql(at)postgresql(dot)org
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)
Date: 2005-04-14 22:24:40
Message-ID: 425EEDA8.80506@mochima.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

And also, really finish the transaction right after the last
statement is executed, instead of waiting until the COMMIT
is issued :-)

Carlos
--

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-04-14 23:20:10 Re: row-attribute in EXPLAIN-output doesn't match count(*)
Previous Message Andreas Joseph Krogh 2005-04-14 21:15:35 Re: row-attribute in EXPLAIN-output doesn't match count(*)