Group commit and commit delay/siblings

Поиск
Список
Период
Сортировка
От Rob Wultsch
Тема Group commit and commit delay/siblings
Дата
Msg-id AANLkTik3dr076BMQ6MqCLZZ0x2-qxmQgWoqCR7c0ePoD@mail.gmail.com
обсуждение исходный текст
Ответы Re: Group commit and commit delay/siblings
Список pgsql-performance
Manual: http://www.postgresql.org/docs/9.0/static/runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS
Recent discussion:
http://www.facebook.com/notes/mysql-at-facebook/group-commit-in-postgresql/465781235932

It is my understanding that group commit in PG works without the
commit_delay or commit_siblings being enabled. For many people coming
from other databases, the existence of these GUC seems to suggest that
group commit does not work without the being enabled.

Are these setting useful, and if so how should they be tuned?
If they are generally are not useful, should these settings be removed?

--
Rob Wultsch
wultsch@gmail.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT
Следующее
От: Jignesh Shah
Дата:
Сообщение: Re: Group commit and commit delay/siblings