| 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 08:12:07 |
| Message-ID: | 3cb78dcf-e344-e7ca-3c52-51b1f0b6621d@koumakan.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 29.10.2021 4:50, Peter Geoghegan wrote:
> Access to the WAL archive would be great. Now might be a good time to
> set "log_min_autovacuum_duration=0" in postgresql.conf -- that
> information might be very helpful later on. This will appear in the
> system logs for PostgreSQL. We'll be particularly interested in the
> "page" table, for the obvious reason.
It looks like this parameter is named "log_autovacuum_min_duration"
instead. Done.
> Also, can you please post output of the following on your server:
> "select * from pg_settings where setting != boot_val;"
Attached; this was done before the above.
--
K. R.
| Attachment | Content-Type | Size |
|---|---|---|
| settings.txt | text/plain | 17.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kamigishi Rei | 2021-10-29 08:17:49 | Re: BUG #17245: Index corruption involving deduplicated entries |
| Previous Message | Alexander Kukushkin | 2021-10-29 08:10:41 | Re: BUG #17245: Index corruption involving deduplicated entries |