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

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Pre-set Hint bits/VACUUM FREEZE on data load..?
Дата
Msg-id 20110324215113.GI4116@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Pre-set Hint bits/VACUUM FREEZE on data load..?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> Also, you're not really going to get the whole benefit unless you can
> somehow manage to mark the pages PD_ALL_VISIBLE and set the visibility
> map bits.  Without that, the next vacuum is going to dirty the whole
> heap anyway.  Granted that's a bit better than having the next scan do
> it.

If the premise that we can do just-about-whatever with the relation (and
any sub-components, TOAST table, visibility map, etc) since it was
created in the same transaction and therefore isn't visible outside,
then I don't think that setting the visibility map bits would be a
problem..
Thanks,
    Stephen

В списке pgsql-hackers по дате отправления:

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