Re: pg_restore taking 4 hours!

From: Hannu Krosing
Subject: Re: pg_restore taking 4 hours!
Date: ,
Msg-id: 1102417717.3916.5.camel@fuji.krosing.net
(view: Whole thread, Raw)
In response to: Re: pg_restore taking 4 hours!  (Rodrigo Carvalhaes)
List: pgsql-performance

Tree view

pg_restore taking 4 hours!  (Rodrigo Carvalhaes, )
 Re: pg_restore taking 4 hours!  (Shridhar Daithankar, )
  Re: [GENERAL] pg_restore taking 4 hours!  (Tom Lane, )
  Re: [GENERAL] pg_restore taking 4 hours!  ("Riccardo G. Facchini", )
  Re: pg_restore taking 4 hours!  (Rodrigo Carvalhaes, )
   Re: pg_restore taking 4 hours!  (Hannu Krosing, )
 Re: pg_restore taking 4 hours!  (Josh Berkus, )
 Re: pg_restore taking 4 hours!  (Andrew McMillan, )
 Re: pg_restore taking 4 hours!  (Vivek Khera, )
  Re: pg_restore taking 4 hours!  (Josh Berkus, )
 Re: pg_restore taking 4 hours!  (Josh Berkus, )
  Re: pg_restore taking 4 hours!  (Tom Lane, )
 Re: pg_restore taking 4 hours!  ("Iain", )

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:

From: Andrew Sullivan
Date:
Subject: Re: Config review
From: "Stacy White"
Date:
Subject: Re: Partitioned table performance