Re: Bulk INSERT performance in 7.4.1

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: Bulk INSERT performance in 7.4.1
Дата
Msg-id x7r7w9smii.fsf@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на Bulk INSERT performance in 7.4.1  (Florian Weimer <fw@deneb.enyo.de>)
Ответы Re: Bulk INSERT performance in 7.4.1
Re: Bulk INSERT performance in 7.4.1
Список pgsql-performance
>>>>> "FW" == Florian Weimer <fw@deneb.enyo.de> writes:

FW> After increasing the number of checkpoint segments and the shared-memory
FW> buffers, performance is back to the expected levels.  It might even be a
FW> bit faster.

If you've got the time, could you try also doing the full bulk insert
test with the checkpoint log files on another physical disk?  See if
that's any faster.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Scaling further up
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Bulk INSERT performance in 7.4.1