Re: Postgres 8.3 HOT and non-persistent xids - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Postgres 8.3 HOT and non-persistent xids
Date
Msg-id 20071220110554.GB5701@merkur.hilbert.loc
Whole thread Raw
In response to Re: Postgres 8.3 HOT and non-persistent xids  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, Dec 20, 2007 at 12:55:02AM -0500, Tom Lane wrote:

> "Mike C" <smith.not.western@gmail.com> writes:
> > And for non-persistent transaction ids, the documentation says that
> > this is for read-only transactions. What defines a read-only
> > transaction for this purpose?
>
> A transaction that has not done anything that requires it to sign an
> update with its transaction ID.

In this context, when I set a connection to READ ONLY do any
transactions run on the connection ever bother to do any of
the transactional-writes housekeeping (such as txid
signing) ?

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Quick Regex Question
Next
From: Richard Huxton
Date:
Subject: Re: Quick Regex Question