Re: pg_restore takes ages

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: pg_restore takes ages
Дата
Msg-id Pine.LNX.4.33.0310031428170.28179-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: pg_restore takes ages  (Vivek Khera <khera@kcilink.com>)
Список pgsql-general
On Fri, 3 Oct 2003, Vivek Khera wrote:

> >>>>> "sm" == scott marlowe <scott.marlowe> writes:
>
> sm> also, turning off fsync during the load helps a lot.  Be sure to turn it
> sm> back on when you're done of course.
>
> Only if you don't have a battery-backed cache on your RAID.  If you
> do, it won't likely make a big difference.  For me it was about 2
> seconds over a 4-hour restore.

True, very true.  Have you done the "pull the plug" test on it to make
sure it really works, by the way?


В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: pg_restore takes ages
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: [PERFORM] Postgres low end processing.