Re: Pre-set Hint bits/VACUUM FREEZE on data load..? - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Pre-set Hint bits/VACUUM FREEZE on data load..?
Date
Msg-id 20110324214729.GH4116@tamriel.snowman.net
Whole thread Raw
In response to Re: Pre-set Hint bits/VACUUM FREEZE on data load..?  (Greg Stark <gsstark@mit.edu>)
Responses Re: Pre-set Hint bits/VACUUM FREEZE on data load..?
List pgsql-hackers
* Greg Stark (gsstark@mit.edu) wrote:
> I'm not sure this solves the cases of subtransactions -- but perhaps
> we just wouldn't store frozenxid if we're in a subtransaction. And I'm
> not sure we have access to the relation id when we're doing visibility
> checks. I think we do. This would involve no serious ugliness in the
> actual on-disk storage and it would make data loads a write-once
> operation which is the holy grail :)

I'd be happy with a "data loading mode" that even disallowed
subtransactions if necessary to achieve the write-once (well, plus WAL
if you're archiving) operation...
    Thanks,                Stephen

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Param symbols and collations
Next
From: Stephen Frost
Date:
Subject: Re: Pre-set Hint bits/VACUUM FREEZE on data load..?