Re: CREATE TABLE, load and freezing - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: CREATE TABLE, load and freezing
Date
Msg-id 47C6E474.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to CREATE TABLE, load and freezing  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-hackers
>>> 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




pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Need Mentors for Google Summer of Code!
Next
From: "Kevin Grittner"
Date:
Subject: Re: Google SoC 2008?