Re: IPC/MultixactCreation on the Standby server

Andrey Borodin <x4mmm@yandex-team.ru>

View thread

From: Andrey Borodin <x4mmm@yandex-team.ru>

To: Dmitry <dsy.075@yandex.ru>

Cc: Álvaro Herrera <alvherre@kurilemu.de>, pgsql-hackers@lists.postgresql.org

Date: 2025-07-31T06:29:25Z

Lists: pgsql-hackers

Attachments

v9-0001-Avoid-edge-case-2-in-multixacts.patch (application/octet-stream) patch v9-0001
v9-PG17-0001-Avoid-edge-case-2-in-multixacts.patch (application/octet-stream) patch v9-0001

> On 29 Jul 2025, at 23:15, Andrey Borodin <x4mmm@yandex-team.ru> wrote:
> 
> I do not understand it yet.

OK, I figured it out. SimpleLruDoesPhysicalPageExist() was reading a physical file and could race with real extension by ExtendMultiXactOffset().
So I used ExtendMultiXactOffset(actual + 1). I hope this does not open a loop for wraparound...

Here's an updated two patches, one for Postgres 17 and one for mater(with a test).

Best regards, Andrey Borodin.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix test to work with non-8kB block sizes
- 7c2061bdfba7 19 (unreleased) landed
Fix setting next multixid's offset at offset wraparound
- 48969555447f 14.21 landed
- b9a02b9780bc 15.16 landed
- 4d689a17693e 16.12 landed
- cad40cec24f3 17.8 landed
- 02ba5e3be4f3 18.2 landed
- 4d936c3fff1a 19 (unreleased) landed
Add test for multixid wraparound
- 7b81be9b4267 19 (unreleased) landed
Set next multixid's offset when creating a new multixid
- 81416e1016dd 14.21 landed
- 8cfb174a61eb 15.16 landed
- 635166913078 16.12 landed
- 8ba61bc06386 17.8 landed
- e46041fd973c 18.2 landed
- 789d65364cde 19 (unreleased) landed
psql: Improve tab completion for large objects.
- 14ee8e640300 19 (unreleased) cited
Refactor some repetitive SLRU code
- c61678551699 19 (unreleased) cited
Transaction IDs wrap around, per my proposal of 13-Aug-01. More
- bc7d37a525c0 7.2.1 cited