Re: [GENERAL] [PERFORM] pg_restore taking 4 hours!

2004-12-01 Thread Josh Berkus
Rodrigo, > Our machine it's a Dell Server Power Edge 1600sc (Xeon 2,4Ghz, with 1GB > memory, 7200 RPM disk). I don't think that there is a machine problem > because it's a server dedicated for the database and the cpu utilization > during the restore is around 30%. In addition to Tom and Shridhar

Re: [GENERAL] [PERFORM] pg_restore taking 4 hours!

2004-12-01 Thread Tom Lane
Shridhar Daithankar <[EMAIL PROTECTED]> writes: > On Wednesday 01 Dec 2004 4:46 pm, Rodrigo Carvalhaes wrote: >> I need to find a solution for this because I am convincing customers >> that are using SQL Server, DB2 and Oracle to change to PostgreSQL but >> this customers have databases of 5GB!!! I

Re: [GENERAL] [PERFORM] pg_restore taking 4 hours!

2004-12-01 Thread Riccardo G. Facchini
--- Shridhar Daithankar <__> wrote: > On Wednesday 01 Dec 2004 4:46 pm, Rodrigo Carvalhaes wrote: > > I need to find a solution for this because I am convincing > customers > > that are using SQL Server, DB2 and Oracle to change to PostgreSQL > but > > this customers have databases of 5GB!!! I am

Re: [GENERAL] [PERFORM] pg_restore taking 4 hours!

2004-12-01 Thread Shridhar Daithankar
On Wednesday 01 Dec 2004 4:46 pm, Rodrigo Carvalhaes wrote: > I need to find a solution for this because I am convincing customers > that are using SQL Server, DB2 and Oracle to change to PostgreSQL but > this customers have databases of 5GB!!! I am thinking that even with a > better server, the re