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 <grupos@carvalhaes.net>)
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Config review
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Config review