Re: pg_restore taking 4 hours!

Hannu Krosing <hannu@tm.ee>

From: Hannu Krosing <hannu@tm.ee>
To: grupos@carvalhaes.net
Cc: pgsql-performance@postgresql.org
Date: 2004-12-07T11:08:38Z
Lists: pgsql-performance
On P, 2004-12-05 at 21:43, Rodrigo Carvalhaes wrote:
> Hi !
> 
> Thanks for the lots of tips that I received on this matter.
> 
...
> There is something more that I can try to improve this performance?

check the speed of your ide drive. maybe tweak some params with
/sbin/hdparm . Sometimes the defaults result in 2MB/sec r/w speeds
(instead on(30-70 MB/sec)

------------
Hannu