Re: [HACKERS] On markers of changed data

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: [HACKERS] On markers of changed data
Дата
Msg-id 6446B8AA-C7D4-4561-847F-6907FB2F34EE@yandex-team.ru
обсуждение исходный текст
Ответ на Re: [HACKERS] On markers of changed data  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: [HACKERS] On markers of changed data  (Michael Paquier <michael.paquier@gmail.com>)
Re: [HACKERS] On markers of changed data  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-hackers
> 8 окт. 2017 г., в 20:11, Stephen Frost <sfrost@snowman.net> написал(а):
> * Andrey Borodin (x4mmm@yandex-team.ru) wrote:
>> But my other question still seems unanswered: can I use LSN logic for incrementing FSM and VM? Seems like most of
thetime there is valid LSN 
>
> I haven't gone and audited it myself, but I would certainly expect you
> to be able to use the LSN for everything which is WAL'd.  If you have
> cases where that's not the case, it'd be useful to see them.

Thanks, Stephen, this actually pointed what to look for
VM is WAL-logged [0]
FSM is not [1]

Now I have everything I wanted, and go back coding :)

Best regards, Andrey Borodin.

[0]
https://github.com/postgres/postgres/blob/113b0045e20d40f726a0a30e33214455e4f1385e/src/backend/access/heap/visibilitymap.c#L315
[1]
https://github.com/postgres/postgres/blob/1d25779284fe1ba08ecd57e647292a9deb241376/src/backend/storage/freespace/freespace.c#L593

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: [HACKERS] Discussion on missing optimizations
Следующее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables