Postgres Pro
Downloads
Home   >   mailing lists

Re: testing framework for MVCC & vacuum (freeze) & heap_page_prune etc. - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: testing framework for MVCC & vacuum (freeze) & heap_page_prune etc.
Date
Msg-id BB534A9D-6C9A-410E-86A7-D00E3D5A7CF4@yandex-team.ru
Whole thread Raw
In response to testing framework for MVCC & vacuum (freeze) & heap_page_prune etc.  (Andy Fan <zhihuifan1213@163.com>)
Responses Re: testing framework for MVCC & vacuum (freeze) & heap_page_prune etc.
List pgsql-hackers
Tree view 

> On 10 Dec 2024, at 08:31, Andy Fan <zhihuifan1213@163.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
variousqueries. 
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

pgsql-hackers by date:

Previous
From: Andy Fan
Date:
Subject: Re: testing framework for MVCC & vacuum (freeze) & heap_page_prune etc.
Next
From: Dilip Kumar
Date:
Subject: Re: Track the amount of time waiting due to cost_delay