RESTORE IS TO SLOW - Mailing list pgsql-admin

From marvin.deoliveira
Subject RESTORE IS TO SLOW
Date
Msg-id 1316125973378-4808653.post@n5.nabble.com
Whole thread Raw
Responses Re: RESTORE IS TO SLOW  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-admin
Hi.
I'm restoring a database (only rows) that has some tables with 9 millions
rows and others have even more.
It's going to slow ( more than 24 hours by now ).
I'm disabling the triggers but I guess if I drop the indexes it will have
more performance. Am I right?
If yes, does anyone have a script that generates the drop and create
indexes?






-----
Marcos Oliveira
And I still haven't found what I'm looking for...
--
View this message in context: http://postgresql.1045698.n5.nabble.com/RESTORE-IS-TO-SLOW-tp4808653p4808653.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: database size much bigger than tablespaces on filesystem
Next
From: Lonni J Friedman
Date:
Subject: Re: RESTORE IS TO SLOW