Re: Unit tests for SLRU - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Unit tests for SLRU
Date
Msg-id Y3IkLPWdhGWlMMvJ@paquier.xyz
Whole thread Raw
In response to Re: Unit tests for SLRU  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Unit tests for SLRU
List pgsql-hackers
On Fri, Nov 11, 2022 at 02:11:08PM +0900, Michael Paquier wrote:
> Is there a reason why you need a TAP test here?  It is by design more
> expensive than pg_regress and it does not require --enable-tap-tests.
> See for example what we do for snapshot_too_old, commit_ts,
> worker_spi, etc., where each module uses a custom configuration file.

I have put my hands on that, and I found that the tests were a bit
overengineered.  First, SimpleLruDoesPhysicalPageExist() is not that
much necessary before and after each operation, like truncation or
deletion, as the previous pages were doing equal tests.  The hardcoded
page number lacks a bit of flexibility and readability IMO, especially
when combined with the number of pages per segments, as well.

I have reworked that as per the attached, that provides basically the
same coverage, going through a SQL interface for the whole thing.
Like all the other tests of its kind, this does not use a TAP test,
relying on a custom configuration file instead.  This still needs some
polishing, but the basics are here.

What do you think?
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: Privileges on PUBLICATION
Next
From: Thom Brown
Date:
Subject: Re: Add 64-bit XIDs into PostgreSQL 15