Re: [HACKERS] Fix checkpoint skip logic on idle systems by trackingLSN progress

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [HACKERS] Fix checkpoint skip logic on idle systems by trackingLSN progress
Дата
Msg-id CAB7nPqTce8tZVLL_d83ftsQSDbPY59p_A=DT5-+scoC44WYyBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Fix checkpoint skip logic on idle systems by trackingLSN progress  (David Steele <david@pgmasters.net>)
Список pgsql-hackers
On Thu, Dec 22, 2016 at 6:41 AM, David Steele <david@pgmasters.net> wrote:
> On 12/21/16 4:28 PM, Andres Freund wrote:
>
>> Working on committing this (tomorrow morning, not tonight).  There's
>> some relatively minor things I want to change:

Thanks for looking at this patch.

>> - I don't like the name XLogSetFlags() - it's completely unclear what
>>   that those flags refer to - it could just as well be replay
>>   related. XLogSetRecordFlags()?
>
> That sounds a bit more clear.

Fine for me.

>> - Similarly I don't like the name "progress LSN" much. What does
>>   "progress" really mean in that". Maybe "consistency LSN"?
>
> Yes, please.  I think that really cuts to the core of what the patch is
> about.  Progress made perfect sense to me, but consistency is always the
> goal, and what we are saying here is that this is the last xlog record that
> is required to achieve consistency.  Anything that happens to be after it is
> informational only.

Fine as well.

>> - It's currently required to avoid triggering archive timeouts and
>>   checkpoints triggering each other, but I'm nervous marking all xlog
>>   switches as unimportant. I think it'd be better to only mark timeout
>>   triggered switches as such.
>
> That seems fine to me.  If the system is truly idle that might trigger one
> more xlog switch that is needed, but it seems like a reasonable compromise.

On a long-running embedded system the difference won't matter much. So
I guess I'm fine with this bit as well.
-- 
Michael



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Fix checkpoint skip logic on idle systems by trackingLSN progress
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] Hang in pldebugger after git commit : 98a64d0