Re: pg_restore taking 4 hours! - Mailing list pgsql-performance

From Hannu Krosing
Subject Re: pg_restore taking 4 hours!
Date
Msg-id 1102417717.3916.5.camel@fuji.krosing.net
Whole thread Raw
In response to Re: pg_restore taking 4 hours!  (Rodrigo Carvalhaes <grupos@carvalhaes.net>)
List 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


pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: Config review
Next
From: Tom Lane
Date:
Subject: Re: Config review