Re: Rapidly decaying performance repopulating a large table

Поиск
Список
Период
Сортировка
От David Wilson
Тема Re: Rapidly decaying performance repopulating a large table
Дата
Msg-id e7f9235d0804221446k5de18bc6s1b55c8cd3cfd93b3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Rapidly decaying performance repopulating a large table  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Rapidly decaying performance repopulating a large table
Re: Rapidly decaying performance repopulating a large table
Список pgsql-general
On Tue, Apr 22, 2008 at 5:18 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>
>  Try upping your checkpoint segments.  Some folks find fairly large
>  numbers like 50 to 100 to be helpful.  Each segment = 16Megs, so be
>  sure not to run your system out of drive space while increasing it.
>

Ahh, much more progress. Upping the segments to 50, timeout to 30m and
completion target to 0.9 has improved average copy time to between 2
and 10 seconds, which is definitely an improvement. Thanks for the
help. Any other random thoughts while you're at it? :)

--
- David T. Wilson
david.t.wilson@gmail.com

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

Предыдущее
От: "D. Dante Lorenso"
Дата:
Сообщение: Re: How to modify ENUM datatypes?
Следующее
От: Erik Jones
Дата:
Сообщение: Re: Schema migration tools?