From: | Kamigishi Rei <iijima(dot)yun(at)koumakan(dot)jp> |
---|---|
To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
Subject: | Re: BUG #17245: Index corruption involving deduplicated entries |
Date: | 2021-10-29 19:37:15 |
Message-ID: | 7a5305a8-fde0-6074-9a2e-9233eb66b3a0@koumakan.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2021-10-29 19:41:47 | Re: BUG #17245: Index corruption involving deduplicated entries |
Previous Message | David M. Calascibetta | 2021-10-29 19:32:48 | FW: BUG #17258: Unexpected results in CHAR(1) data type |