Postgres Pro
Downloads
Home   >   mailing lists

Re: dump / restore questions - Mailing list pgsql-general

From Tom Lane
Subject Re: dump / restore questions
Date
Msg-id 2875.1085380057@sss.pgh.pa.us
Whole thread Raw
In response to dump / restore questions  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Tree view 
Joseph Shraibman <jks@selectacast.net> writes:
> I recently dumped and restored a 7.4.2 database.  It took 30 minutes for
> the data to load (6 gig) and 45 for the indexes to be created (3 gig).

Increasing sort_mem might help.

> Why are the primary keys created after the other indexes?

AFAICS in CVS tip, they're created together.

            regards, tom lane

pgsql-general by date:

Previous
From: Marc Slemko
Date:
Subject: Re: how many record versions
Next
From: Brendan Jurd
Date:
Subject: PL/pgSQL: FOUND not set by EXECUTE?