Re: Planning time is time-consuming
David Rowley <dgrowleyml@gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Mikhail Balayan <mv.balayan@gmail.com>, pgsql-performance@postgresql.org
Date: 2023-09-11T08:24:35Z
Lists: pgsql-performance
On Mon, 11 Sept 2023 at 18:16, Laurenz Albe <laurenz.albe@cybertec.at> wrote: > Also, there are quite a lot of indexes on "test_db_bench_1". On a test database, drop some > indexes and see if that makes a difference. Yeah, I count 3 that either have the key columns as some prefix of another index or are just a duplicate of some other index. Getting rid of those 3 will save some time in create_index_paths(). David