Re: dump / restore questions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dump / restore questions
Date: 2004-05-24 06:27:37
Message-ID: 2875.1085380057@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joseph Shraibman <jks(at)selectacast(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Jurd 2004-05-24 09:55:24 PL/pgSQL: FOUND not set by EXECUTE?
Previous Message Marc Slemko 2004-05-24 06:23:28 Re: how many record versions