| From: | Kamigishi Rei <iijima(dot)yun(at)koumakan(dot)jp> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Cc: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, 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-30 07:47:09 |
| Message-ID: | 752a16e4-dbe4-eaaf-bc4c-e48d2885f18d@koumakan.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 30.10.2021 5:37, Andres Freund wrote:
> The problem is that parallel vacuum doesn't have correct handling for small
> indexes, when there are other indexes that are big enough to use parallelism.
Index sizes in use (pg_total_relation_size), btree only, with only the
largest, the smallest, and those reported by pg_amcheck listed:
┌───────────────────────────────────┬──────────────┬────────────┐
│ index │ index_method │ index_size │
├───────────────────────────────────┼──────────────┼────────────┤
│ pl_backlinks_namespace │ btree │ 18 MB │
│ pl_namespace │ btree │ 16 MB │
│ wl_user │ btree │ 6416 kB │
│ … │ … │ … │
│ page_redirect_namespace_len │ btree │ 544 kB │
│ … │ … │ … │
│ page_len │ btree │ 488 kB │
│ … │ … │ … │
│ transcode_key_idx │ btree │ 192 kB │
│ … │ … │ … │
│ page_main_title │ btree │ 144 kB │
│ … │ … │ … │
│ ir_type_value │ btree │ 8192 bytes │
│ ipc_hex_time │ btree │ 8192 bytes │
└───────────────────────────────────┴──────────────┴────────────┘
--
K. R.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sandeep Thakkar | 2021-10-30 07:59:27 | Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data |
| Previous Message | Andrey Borodin | 2021-10-30 07:26:01 | Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data |