Re: Read Uncommitted - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Read Uncommitted
Date
Msg-id 23322.1211822747@sss.pgh.pa.us
Whole thread Raw
In response to Re: Read Uncommitted  (Hannu Krosing <hannu@krosing.net>)
Responses Re: Read Uncommitted  (Hannu Krosing <hannu@krosing.net>)
Re: Read Uncommitted  (Simon Riggs <simon@2ndquadrant.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERRORDATA_STACK_SIZE panic crashes on Windows
Next
From: Jeff Davis
Date:
Subject: Re: Proposal: temporal extension "period" data type