>>> On Thu, Feb 28, 2008 at 3:08 AM, in message
<2e78013d0802280108s59e52e14hae032e1e67409d6c(at)mail(dot)gmail(dot)com>, "Pavan Deolasee"
<pavan(dot)deolasee(at)gmail(dot)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