| From: | "marvin(dot)deoliveira" <marvin(dot)deoliveira(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | RESTORE IS TO SLOW |
| Date: | 2011-09-15 22:32:53 |
| Message-ID: | 1316125973378-4808653.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lonni J Friedman | 2011-09-15 22:38:24 | Re: RESTORE IS TO SLOW |
| Previous Message | Tom Lane | 2011-09-14 21:05:55 | Re: database size much bigger than tablespaces on filesystem |