Re: POC and rebased patch for CSN based snapshots

Поиск
Список
Период
Сортировка
От movead.li@highgo.ca
Тема Re: POC and rebased patch for CSN based snapshots
Дата
Msg-id 2020061912364160415939@highgo.ca
обсуждение исходный текст
Ответ на POC and rebased patch for CSN based snapshots  (Movead Li <movead.li@highgo.ca>)
Ответы Re: POC and rebased patch for CSN based snapshots  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список pgsql-hackers

>You mean that the last generated CSN needs to be WAL-logged because any smaller
>CSN than the last one should not be reused after crash recovery. Right?
Yes that's it. 

>If right, that WAL-logging seems not necessary because CSN mechanism assumes
>CSN is increased monotonically. IOW, even without that WAL-logging, CSN afer
>crash recovery must be larger than that before. No?

CSN collected based on time of  system in this patch, but time is not reliable all the
time. And it designed for Global CSN(for sharding) where it may rely on CSN from
other node , which generated from other machine. 

So monotonically is not reliable and it need to keep it's largest CSN in wal in case
of crash.


Regards,
Highgo Software (Canada/China/Pakistan)
URL : www.highgo.ca
EMAIL: mailto:movead(dot)li(at)highgo(dot)ca

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Missing HashAgg EXPLAIN ANALYZE details for parallel plans
Следующее
От: vignesh C
Дата:
Сообщение: Re: Cleanup - Removal of unused function parameter from CopyReadBinaryAttribute