Re: Idea for getting rid of VACUUM FREEZE on cold pages

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Idea for getting rid of VACUUM FREEZE on cold pages
Дата
Msg-id 4BFE90CE0200002500031BA7@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Idea for getting rid of VACUUM FREEZE on cold pages  (Joe Conway <mail@joeconway.com>)
Список pgsql-hackers
>>>Joe Conway <mail@joeconway.com> wrote:
> (a) can work if it is all in one command, CREATE TABLE AS
> SELECT...
> Additionally we were discussing COPY in the FROM clause, which
> means you could CREATE TABLE AS SELECT ... FROM (COPY ...). That
> would allow bulk loading with hint bits already set (and tuples
> frozen?).
As long as it's hinted and frozen after a pg_dump -1 | psql I'll be
happy.
-Kevin


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Synchronization levels in SR
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Exposing the Xact commit order to the user