pg.ddx.io pgsql-bugs@postgresql.org mailing list archive help / color / mirror / Atom feed From: Kamigishi Rei <iijima.yun@koumakan.jp>
To: Andres Freund <andres@anarazel.de>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: Thomas Munro <thomas.munro@gmail.com>
Subject: Re: BUG #17245: Index corruption involving deduplicated entries
Date: Sat, 30 Oct 2021 10:47:09 +0300
Message-ID: <752a16e4-dbe4-eaaf-bc4c-e48d2885f18d@koumakan.jp> (raw )
In-Reply-To: <20211030023740.qbnsl2xaoh2grq3d@alap3.anarazel.de >
References: <125603c4-4403-dcbb-221e-fd1d4ef6ed83@koumakan.jp >
<20211028220124.n4vulzxp6i6fsq4t@alap3.anarazel.de >
<551936fa-9ba8-aed1-7ae1-c77d5920101c@koumakan.jp >
<9c7433f6-65b3-9f57-e8a3-4414d0cf0c53@koumakan.jp >
<399affa1-c9c5-9b3e-c14f-b24ecb86b303@koumakan.jp >
<20211029201848.zixfp5wk2hvkeaq2@alap3.anarazel.de >
<ed307eed-ef62-c33b-3b25-fcea76713417@koumakan.jp >
<20211029213048.q5ltta6dze3sykh3@alap3.anarazel.de >
<20211029215902.7um7dmzl4lveuk3h@alap3.anarazel.de >
<8809ef6d-d247-5ca8-820d-b9daec61e818@koumakan.jp >
<20211030023740.qbnsl2xaoh2grq3d@alap3.anarazel.de >
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.
view thread (103+ messages) latest in thread
Message-ID: <752a16e4-dbe4-eaaf-bc4c-e48d2885f18d@koumakan.jp>
Permalink: ../752a16e4-dbe4-eaaf-bc4c-e48d2885f18d@koumakan.jp/
Also on: postgresql.org/message-id/752a16e4-dbe4-eaaf-bc4c-e48d2885f18d@koumakan.jp
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: iijima.yun@koumakan.jp, andres@anarazel.de, amit.kapila16@gmail.com, andrew@tao11.riddles.org.uk, alvherre@alvh.no-ip.org, pg@bowt.ie, pgsql-bugs@lists.postgresql.org, thomas.munro@gmail.com
Subject: Re: BUG #17245: Index corruption involving deduplicated entries
In-Reply-To: <752a16e4-dbe4-eaaf-bc4c-e48d2885f18d@koumakan.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox