Re: synchronous_commit=off doesn't always return immediately

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: synchronous_commit=off doesn't always return immediately
Дата
Msg-id 16291.1248360298@sss.pgh.pa.us
обсуждение исходный текст
Ответ на synchronous_commit=off doesn't always return immediately  (tomrevam <tomer@fabrix.tv>)
Ответы Re: synchronous_commit=off doesn't always return immediately
Список pgsql-general
Дерево обсуждения 
tomrevam <tomer@fabrix.tv> writes:
> I set synchronous_commit to off and expected trivial inserts (single row,
> 6-8 columns) to always return quickly. However, I see that during
> checkpoints they sometimes take over a second.

What sort of disk hardware have you got?  It sounds overstressed.

It might help to increase wal_buffers.

            regards, tom lane

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: comparing NEW and OLD (any good this way?)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: unexpected data beyond EOF in block of relation "RelationName"