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 по дате отправления: