Re: CREATE TABLE, load and freezing

>>> On Thu, Feb 28, 2008 at  3:08 AM, in message
<2e78013d0802280108s59e52e14hae032e1e67409d6c@mail.gmail.com>, "Pavan Deolasee"
<pavan.deolasee@gmail.com> wrote:
> I had this idea sometime back. Not sure if this has been discussed before
There was a thread discussing the problems you're looking to address:
http://archives.postgresql.org/pgsql-performance/2007-12/msg00230.php
> I don't know if this is a real problem for anybody, but I could think
> of its use case, at least in theory.
Yeah, it's real.  We are now doing a VACUUM FREEZE of a table or
database which has been freshly loaded.  If you can load them
frozen and/or with hint bits, that would reduce the time to bring
a database online.  It would be much appreciated here.
-Kevin