Re: Planning time is time-consuming

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Planning time is time-consuming
Дата
Msg-id CAApHDvptg3+=rPK2s1T2bMASu4coYo7ssrkN_Smf8-RVC3sfFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Planning time is time-consuming  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Fwd: Planning time is time-consuming
Следующее
От: David Rowley
Дата:
Сообщение: Re: Planning time is time-consuming