Re: Pre-set Hint bits/VACUUM FREEZE on data load..?

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Pre-set Hint bits/VACUUM FREEZE on data load..?
Дата
Msg-id 20110324214729.GH4116@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Pre-set Hint bits/VACUUM FREEZE on data load..?  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Pre-set Hint bits/VACUUM FREEZE on data load..?
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Param symbols and collations
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Pre-set Hint bits/VACUUM FREEZE on data load..?