Re: Read Uncommitted - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Read Uncommitted
Date
Msg-id 20191218193433.GW3195@tamriel.snowman.net
Whole thread Raw
In response to Re: Read Uncommitted  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Read Uncommitted  ("Finnerty, Jim" <jfinnert@amazon.com>)
List pgsql-hackers
Greetings,

* Robert Haas (robertmhaas@gmail.com) wrote:
> On Wed, Dec 18, 2019 at 1:06 PM Simon Riggs <simon@2ndquadrant.com> wrote:
> > Just consider this part of the recovery toolkit.
>
> I agree that it would be useful to have a recovery toolkit for reading
> uncommitted data, but I think a lot more thought needs to be given to
> how such a thing should be designed. If you just add something called
> READ UNCOMMITTED, people are going to expect it to have *way* saner
> semantics than this will. They'll use it routinely, not just as a
> last-ditch mechanism to recover otherwise-lost data. And I'm
> reasonably confident that will not work out well.

+1.

Thanks,

Stephen

Attachment

pgsql-hackers by date:

Previous
From: Rahila Syed
Date:
Subject: Re: Minimal logical decoding on standbys
Next
From: Vladimir Koković
Date:
Subject: Re: Restore backup file "with oids"