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