Re: Write skew observed under serializable isolation

From: Aleksander Alekseev <aleksander(at)tigerdata(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Jacob Brazeal <jacob(dot)brazeal(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Subject: Re: Write skew observed under serializable isolation
Date: 2026-09-22 12:30:43
Message-ID: CAJ7c6TN_MdeN1Uinwywm=J9ZCGsSs11w217OiT0sP0hdsEcWiA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Andres,

Thanks for the feedback.

> Seems like it'd be good to add a note to the SO_TYPE definitions mentioning
> that this needs to be updated for additional scans.

Good point. Added.

> Do we have test coverage for the bitmap scan cases?

It looks like predicate-lock-hot-tuple.spec sort of covers it but it
is not guaranteed to use bitmap scan and all in all this is a
regression test for another scenario. v4 adds a dedicated test. I
choose not to split the patch into two parts.

--
Best regards,
Aleksander Alekseev

Attachment Content-Type Size
v4-0001-Fix-write-skew-under-SERIALIZABLE-for-TID-range-s.patch text/x-patch 15.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ilia Evdokimov 2026-09-22 12:38:41 Re: Fold NOT IN / <> ALL expressions containing NULL to FALSE
Previous Message Sehrope Sarkuni 2026-09-22 12:28:06 Re: [PATCH] set_byte() with a count argument