Re: how unsafe (or worst scenarios) when setting fsync

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: how unsafe (or worst scenarios) when setting fsync
Дата
Msg-id 4451D95E.9080308@logix-tt.com
обсуждение исходный текст
Ответ на Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql  ("Guoping Zhang" <guoping.zhang@nec.com.au>)
Список pgsql-performance
Дерево обсуждения 
Hk, Guoping,

Guoping Zhang wrote:

> a) The tests consists of ten thousands very small transactions, which are
> not grouped, that is why so slow with compare to set fsync off.

If those transactions are submitted by concurrent applications over
several simulataneous connections, playing with commit_delay and
commit_siblins may improve your situation.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

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

Предыдущее
От: "Mikael Carneholm"
Дата:
Сообщение: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Следующее
От: "Andrus"
Дата:
Сообщение: Re: CPU usage goes to 100%, query seems to ran forever