Re: pg_restore taking 4 hours!

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: grupos(at)carvalhaes(dot)net
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_restore taking 4 hours!
Date: 2004-12-07 11:08:38
Message-ID: 1102417717.3916.5.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Premsun Choltanwanich 2004-12-07 11:11:08 Re: How can I recovery old Data from files and
Previous Message Markus Wollny 2004-12-07 10:14:02 Re: How can I recovery old Data from files and folders on windows?

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2004-12-07 14:52:33 Re: Fwd: 8.0 vs. 7.4 benchmarks
Previous Message Postgres Learner 2004-12-07 09:17:58 Fwd: 8.0 vs. 7.4 benchmarks