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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin