Re: [GENERAL] pg_restore taking 4 hours!

2004-12-02 Thread Joshua D. Drake
Thierry Missimilly wrote: Rodrigo Carvalhaes a écrit : Hi! I am using PostgreSQL with a proprietary ERP software in Brazil. The database have around 1.600 tables (each one with +/- 50 columns). My problem now is the time that takes to restore a dump. My customer database have arount 500mb (on the

Re: [GENERAL] pg_restore taking 4 hours!

2004-12-02 Thread Thierry Missimilly
Rodrigo Carvalhaes a écrit : Hi! I am using PostgreSQL with a proprietary ERP software in Brazil. The database have around 1.600 tables (each one with +/- 50 columns). My problem now is the time that takes to restore a dump. My customer database have arount 500mb (on the disk, not the dump file)

[GENERAL] pg_restore taking 4 hours!

2004-12-01 Thread Rodrigo Carvalhaes
Hi! I am using PostgreSQL with a proprietary ERP software in Brazil. The database have around 1.600 tables (each one with +/- 50 columns). My problem now is the time that takes to restore a dump. My customer database have arount 500mb (on the disk, not the dump file) and I am making the dump wit