Re: PostgreSQL Write Performance

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: PostgreSQL Write Performance
Дата
Msg-id 87iqbe9pi9.fsf@hi-media-techno.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Write Performance  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-general
Greg Smith <greg@2ndquadrant.com> writes:
> If you're OK with the possibility of losing a measurement in the case of a
> system crash

Then I'd say use synchronous_commit = off for the transactions doing
that, trading durability (the 'D' of ACID) against write
performances. That requires 8.3 at least, and will not fsync() before
telling the client the commit is done.

Regards,
--
dim

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

Предыдущее
От: Konrad Garus
Дата:
Сообщение: Rows missing from table despite FK constraint
Следующее
От: Konrad Garus
Дата:
Сообщение: Re: Rows missing from table despite FK constraint