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