Joseph Shraibman <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to