Re: Planning time is time-consuming

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Mikhail Balayan <mv(dot)balayan(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Planning time is time-consuming
Date: 2023-09-11 08:24:35
Message-ID: CAApHDvptg3+=rPK2s1T2bMASu4coYo7ssrkN_Smf8-RVC3sfFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 11 Sept 2023 at 18:16, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Rowley 2023-09-11 10:17:09 Re: Planning time is time-consuming
Previous Message Laurenz Albe 2023-09-11 08:13:26 Re: Fwd: Planning time is time-consuming