| From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: On markers of changed data |
| Date: | 2017-10-09 05:23:06 |
| Message-ID: | 6446B8AA-C7D4-4561-847F-6907FB2F34EE@yandex-team.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 8 окт. 2017 г., в 20:11, Stephen Frost <sfrost(at)snowman(dot)net> написал(а):
> * Andrey Borodin (x4mmm(at)yandex-team(dot)ru) wrote:
>> But my other question still seems unanswered: can I use LSN logic for incrementing FSM and VM? Seems like most of the time 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Bapat | 2017-10-09 06:05:24 | Re: Partition-wise join for join between (declaratively) partitioned tables |
| Previous Message | David Rowley | 2017-10-09 04:47:50 | Re: Discussion on missing optimizations |