Re: Read Uncommitted

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Read Uncommitted
Дата
Msg-id 23322.1211822747@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Read Uncommitted  (Hannu Krosing <hannu@krosing.net>)
Ответы Re: Read Uncommitted  (Hannu Krosing <hannu@krosing.net>)
Re: Read Uncommitted  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Hannu Krosing <hannu@krosing.net> writes:
> On Mon, 2008-05-26 at 16:55 +0200, Peter Eisentraut wrote:
>> If the data in a table never changes, why would VACUUM or HOT need to touch 
>> it?  The use case isn't clear to me.

> I guess the use-case is about a long read-write transaction doing
> read-only access to an update-only table and thus blocking vacuum on
> other tables.

... in which case the proposed kluge would result in unstable,
unpredictable answers, so there is still no plausible use-case.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERRORDATA_STACK_SIZE panic crashes on Windows
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Proposal: temporal extension "period" data type