Re: BUG #17245: Index corruption involving deduplicated entries

On 29.10.2021 22:20, Peter Geoghegan wrote:

> BTW, can you look for autovacuum log output for the "page" table from
> the logs? Then share it with the list, or at least share it with me
> privately?

I am afraid the severity level of autovacuum was too low for the default 
syslog configuration on FreeBSD. I changed it just now to log *.* to a 
separate file and I can see autovacuum messages for other databases 
appear there now.

The page table has not been autovacuum'd since the 5th of October (the 
13.3 to 14 upgrade day). The only tables that underwent autovacuum since 
that time were

         relname        |          last_vacuum          | 
last_autovacuum
-----------------------+-------------------------------+-------------------------------
  user_properties       | 2021-10-29 12:31:09.849931+09 | 2021-10-22 
12:41:37.727299+09
  cargo_pages           | 2021-10-29 12:31:08.925664+09 | 2021-10-24 
21:53:27.063671+09
  querycache_info       | 2021-10-29 12:31:11.49013+09  | 2021-10-28 
14:53:44.448064+09
  site_stats            | 2021-10-29 12:31:12.296138+09 | 2021-10-29 
00:16:27.778438+09
  job                   | 2021-10-29 12:31:11.897731+09 | 2021-10-30 
00:46:30.479516+09
  objectcache           | 2021-10-29 12:31:05.71646+09  | 2021-10-30 
01:00:33.519683+09

Should I disable the daily vacuum script?

-- 
K. R.