From: | "marvin(dot)deoliveira" <marvin(dot)deoliveira(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: RESTORE IS TO SLOW |
Date: | 2011-09-15 23:12:36 |
Message-ID: | 1316128356637-4808758.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I'm using postgres 9.0.2 32 bits on Debian 5.
The hardware is a pc with 2 GB RAM, with 2 sata disks. Well, that's what I
have at the moment.
The restore was started like: pg_restore -U postgres --data-only
--disable-triggers -v /bck/<dump file>.sql -d <database>
The pg_restore shows:
pg_restore: disabling triggers for <table name>
pg_restore: restoring data for table "<table name>" <- that's taking more
time that I'd like.
pg_restore: enabling triggers for <table name>
I've read the posts that you send, and saw a lot of things that I didn't do.
I'm pretty sure that I'm going to have much better performance after change
the parameters.
But I still have a doubt: Droping the indexes, could give me more
performance?
-----
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-tp4808653p4808758.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Lonni J Friedman | 2011-09-15 23:23:08 | Re: RESTORE IS TO SLOW |
Previous Message | Lonni J Friedman | 2011-09-15 22:38:24 | Re: RESTORE IS TO SLOW |