Re: testing framework for MVCC & vacuum (freeze) & heap_page_prune etc.

From: "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>
To: Andy Fan <zhihuifan1213(at)163(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: testing framework for MVCC & vacuum (freeze) & heap_page_prune etc.
Date: 2024-12-10 03:50:23
Message-ID: BB534A9D-6C9A-410E-86A7-D00E3D5A7CF4@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 10 Dec 2024, at 08:31, Andy Fan <zhihuifan1213(at)163(dot)com> wrote:
>
> I want to know if we have some existing testing framework for
> this area (design, code, licence etc).

I think isolation tests [0] are what you are looking for. These tests are designed to test concurrent execution of various queries.
More subtle race conditions require coordination of injection points [1] or are tested with stochastic tests [2].

Best regards, Andrey Borodin.

[0] https://git.postgresql.org/cgit/postgresql.git/tree/src/test/isolation/README
[1] https://git.postgresql.org/cgit/postgresql.git/tree/src/test/modules/test_misc/t/006_signal_autovacuum.pl#n55
[2] https://git.postgresql.org/cgit/postgresql.git/tree/contrib/amcheck/t/003_cic_2pc.pl

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2024-12-10 04:11:43 Re: Memory leak in WAL sender with pgoutput (v10~)
Previous Message Andy Fan 2024-12-10 03:42:52 Re: testing framework for MVCC & vacuum (freeze) & heap_page_prune etc.