Re: Creation of temporary tables on read-only standby servers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Creation of temporary tables on read-only standby servers
Date
Msg-id 24723.1287431710@sss.pgh.pa.us
Whole thread Raw
In response to Re: Creation of temporary tables on read-only standby servers  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Creation of temporary tables on read-only standby servers
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Oct 18, 2010 at 3:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Andres Freund <andres@anarazel.de> writes:
>>> Hm. Wouldnt it be possible to use virtual xids for that purpose? They are
>>> never seen outside of that session anyway...
>> 
>> Well, maybe, but then you need infrastructure to track whether VXIDs
>> committed or aborted.

> Seems like this would wreak havoc with the HeapTupleSatisfies* functions.

Yeah, it would be messy all over.  This reminds me of last week's
discussion about mysql-style storage engines --- by the time you made
this work, you'd have something darn close to a separate storage engine
for temp tables.  It'd need its own parallel infrastructure covering
everything to do with tuple visibility determination.

It'd be kinda cool if we had it, but the work required to get there
seems far out of proportion to the benefits ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: create tablespace fails silently, or succeeds improperly
Next
From: Bruce Momjian
Date:
Subject: Re: create tablespace fails silently, or succeeds improperly