Re: PgSQL 15.3: Execution plan not using index as expected

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: PgSQL 15.3: Execution plan not using index as expected
Дата
Msg-id fd6c587b-6694-aeb3-063d-38b3243dc455@aklaver.com
обсуждение исходный текст
Ответ на PgSQL 15.3: Execution plan not using index as expected  (Dürr Software <info@fduerr.de>)
Список pgsql-general
Дерево обсуждения 
On 8/9/23 01:14, Dürr Software wrote:
> Dear list,
> 
> i have a strange problem when migrating a DB from version 9.3.4 to 15.3:
> An index which seems perfect for the query and is used in 9.3.4 as 
> expected is not used in 15.3.

Did you run ANALYZE on the 15.3 database after the migration?


-- 
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Ashok Patil
Дата:
Сообщение: Query regarding certificate authentication in postgres
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to set default privilege for new users to have no access to other databases?