Re: Planning time is time-consuming - Mailing list pgsql-performance

From David Rowley
Subject Re: Planning time is time-consuming
Date
Msg-id CAApHDvptg3+=rPK2s1T2bMASu4coYo7ssrkN_Smf8-RVC3sfFQ@mail.gmail.com
Whole thread Raw
In response to Re: Planning time is time-consuming  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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



pgsql-performance by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Fwd: Planning time is time-consuming
Next
From: David Rowley
Date:
Subject: Re: Planning time is time-consuming