Re: Help with count(*) - Mailing list pgsql-performance

From Neil Conway
Subject Re: Help with count(*)
Date
Msg-id 87isllbcys.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: Help with count(*)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Help with count(*)
List pgsql-performance
Tom Lane <tgl@sss.pgh.pa.us> 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


pgsql-performance by date:

Previous
From:
Date:
Subject: Re: Error in transaction processing
Next
From: "Nick Fankhauser"
Date:
Subject: Re: n_distinct way off, but following a pattern.