Re: confusing checkpoint_flush_after / bgwriter_flush_after

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: confusing checkpoint_flush_after / bgwriter_flush_after
Дата
Msg-id 27423.1480093834@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: confusing checkpoint_flush_after / bgwriter_flush_after  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: confusing checkpoint_flush_after / bgwriter_flush_after
Список pgsql-hackers
Fabien COELHO <coelho@cri.ensmp.fr> writes:
>> #checkpoint_flush_after = 0   # 0 disables,
>>                               # default is 256kB on linux, 0 otherwise

>> I find this pretty confusing, because for all other GUCs in the file, the 
>> commented-out value is the default one. In this case that would mean "0", 
>> disabling the flushing.

> Although I understand the issue, I'm not sure about -1 as a special value 
> to mean the default.

Agreed --- I think that's making things more confusing not less.

What we do in some similar cases is put the burden on initdb to fill in
the correct value by modifying postgresql.conf.sample appropriately.
It seems like that could be done easily here too.  And it'd be a
back-patchable fix.
        regards, tom lane



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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: proposal: session server side variables
Следующее
От: Corey Huinker
Дата:
Сообщение: Re: make default TABLESPACE belong to target table.