Horton

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

Alexander Law <exclusion@gmail.com>

View thread View on postgr.es
From: Alexander Lakhin <exclusion@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, Tomas Vondra <tomas.vondra@enterprisedb.com>, Richard Guo <guofenglinux@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Alexander Korotkov <a.korotkov@postgrespro.ru>, Thomas Munro <thomas.munro@gmail.com>
Date: 2024-03-29T10:00:00Z
Lists: pgsql-hackers 
29.03.2024 11:59, Alexander Lakhin wrote:
>
> This simple change fixes the issue for me:
> -VACUUM ANALYZE tenk2;
> +VACUUM (ANALYZE, DISABLE_PAGE_SKIPPING) tenk2;
>

I'm sorry, I wasn't persevering enough when testing that...
After more test runs, I see that in fact it doesn't help.

Best regards,
Alexander

Commits

  1. Try to stabilize flappy test result.