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.