Re: pg_restore taking 4 hours!

От: Hannu Krosing
Тема: Re: pg_restore taking 4 hours!
Дата: ,
Msg-id: 1102417717.3916.5.camel@fuji.krosing.net
(см: обсуждение, исходный текст)
Ответ на: Re: pg_restore taking 4 hours!  (Rodrigo Carvalhaes)
Список: pgsql-performance

Скрыть дерево обсуждения

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 по дате сообщения:

От: Andrew Sullivan
Дата:
Сообщение: Re: Config review
От: "Stacy White"
Дата:
Сообщение: Re: Partitioned table performance