Postgres Pro
Downloads
Home   >   mailing lists

Re: State of Beta 2 - Mailing list pgsql-general

From Tom Lane
Subject Re: State of Beta 2
Date
Msg-id 17737.1064332400@sss.pgh.pa.us
Whole thread Raw
In response to Re: State of Beta 2  (Vivek Khera <khera@kcilink.com>)
Responses Re: State of Beta 2
Re: State of Beta 2
List pgsql-general
Tree view 
Vivek Khera <khera@kcilink.com> writes:
> Well, for me the create index part of the restore is what takes about
> 3x the time for the data load.  Total about 4 hours.  The dump takes 1
> hour.

What sort_mem do you use for the restore?  Have you tried increasing it?

            regards, tom lane

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: About GPL and proprietary software
Next
From: Dennis Gearon
Date:
Subject: Re: About GPL and proprietary software