Re: Postgres 8.3 HOT and non-persistent xids

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: Postgres 8.3 HOT and non-persistent xids
Дата
Msg-id 20071220110554.GB5701@merkur.hilbert.loc
обсуждение исходный текст
Ответ на Re: Postgres 8.3 HOT and non-persistent xids  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Quick Regex Question
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Quick Regex Question