Re: Blocking every 20 sec while mass copying.

Поиск
Список
Период
Сортировка
От Guillaume Cottenceau
Тема Re: Blocking every 20 sec while mass copying.
Дата
Msg-id m3tx6eg0ih.fsf@mnc.ch
обсуждение исходный текст
Ответ на Blocking every 20 sec while mass copying.  (Benjamin Dugast <bdugast@excilys.com>)
Список pgsql-performance
Benjamin Dugast <bdugast 'at' excilys.com> writes:

>   • fsync to off (that helped but we can't do this)

not exactly your question, but maybe synchronous_commit=off is a
nice enough intermediary solution for you (it may give better
performances at other places too for only an affordable cost)

--
Guillaume Cottenceau


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

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: Blocking every 20 sec while mass copying.
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Blocking every 20 sec while mass copying.