Message-ID: <752a16e4-dbe4-eaaf-bc4c-e48d2885f18d@koumakan.jp>
Date: Sat, 30 Oct 2021 10:47:09 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
 Thunderbird/91.2.1
Subject: Re: BUG #17245: Index corruption involving deduplicated entries
To: Andres Freund <andres@anarazel.de>, Amit Kapila <amit.kapila16@gmail.com>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>,
 Alvaro Herrera <alvherre@alvh.no-ip.org>, Peter Geoghegan <pg@bowt.ie>,
 PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>,
 Thomas Munro <thomas.munro@gmail.com>
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>
From: Kamigishi Rei <iijima.yun@koumakan.jp>
In-Reply-To: <20211030023740.qbnsl2xaoh2grq3d@alap3.anarazel.de>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/752a16e4-dbe4-eaaf-bc4c-e48d2885f18d%40koumakan.jp>
Precedence: bulk

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.