Re: Idea for getting rid of VACUUM FREEZE on cold pages - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Idea for getting rid of VACUUM FREEZE on cold pages
Date
Msg-id 4BFE90CE0200002500031BA7@gw.wicourts.gov
Whole thread Raw
In response to Re: Idea for getting rid of VACUUM FREEZE on cold pages  (Joe Conway <mail@joeconway.com>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Synchronization levels in SR
Next
From: Jan Wieck
Date:
Subject: Re: Exposing the Xact commit order to the user