Horton

Re: To what extent should tests rely on VACUUM ANALYZE?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexander Lakhin <exclusion@gmail.com>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>, Richard Guo <guofenglinux@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Alexander Korotkov <a.korotkov@postgrespro.ru>, Thomas Munro <thomas.munro@gmail.com>
Date: 2024-03-29T13:51:24Z
Lists: pgsql-hackers 
Alexander Lakhin <exclusion@gmail.com> writes:
> I think that deviation can be explained by the fact that cost_index() takes
> baserel->allvisfrac (derived from pg_class.relallvisible) into account for
> the index-only-scan case, and I see the following difference when a test
> run fails:
>          relname        | relpages | reltuples | relallvisible | indisvalid | autovacuum_count | autoanalyze_count
>   ----------------------+----------+-----------+---------------+------------+------------------+-------------------
> - tenk1                |      345 |     10000 |           345 |            |                0 |                 0
> + tenk1                |      345 |     10000 |           305 |            |                0 |                 0

Ouch.  So what's triggering that?  The intention of test_setup
surely is to provide a uniform starting point.

			regards, tom lane

Commits

  1. Try to stabilize flappy test result.