From: marvin.deoliveira <marvin.deoliveira@gmail.com>
To: pgsql-admin@postgresql.org
Subject: RESTORE IS TO SLOW
Date: Thu, 15 Sep 2011 15:32:53 -0700 (PDT)
Message-ID: <1316125973378-4808653.post@n5.nabble.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: marvin.deoliveira@gmail.com
Subject: Re: RESTORE IS TO SLOW
In-Reply-To: <1316125973378-4808653.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox