| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Kamigishi Rei <iijima(dot)yun(at)koumakan(dot)jp> |
| 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:41:47 |
| Message-ID: | CAH2-Wzm-qdXxO5esSO1f2LVzPHbJ1zeNREYxnxZN4m4VbH-DBA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Oct 29, 2021 at 12:37 PM Kamigishi Rei <iijima(dot)yun(at)koumakan(dot)jp> wrote:
> 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.
Oh well. It's enabled now, and it doesn't seem to be too hard for you
to reproduce the issue, given time. We can just wait a few more days.
> Should I disable the daily vacuum script?
Please don't change anything. The daily VACUUM script is probably
where the problem actually starts.
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juan José Santamaría Flecha | 2021-10-29 19:43:35 | Re: BUG #17254: Crash with 0xC0000409 in pg_stat_statements when pg_stat_tmp\pgss_query_texts.stat exceeded 2GB. |
| Previous Message | Kamigishi Rei | 2021-10-29 19:37:15 | Re: BUG #17245: Index corruption involving deduplicated entries |