On 2022-Sep-28, Peter Geoghegan wrote:
> It would be useful if there were generic tests that caught issues like
> this. There are various subtle effects related to how struct layout
> can impact WAL record size that might easily be missed. It's not like
> there are a huge number of truly critical WAL records to have tests
> for.
What do you think would constitute a test here?
Say: insert N records to a heapam table with one index of each kind
(under controlled conditions: no checkpoint, no autovacuum, no FPIs),
then measure the total number of bytes used by WAL records of each rmgr.
Have a baseline and see how that changes over time.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/