Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: PgSQL 15.3: Execution plan not using index as expected
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Date: Thu, 10 Aug 2023 07:41:01 -0700
Feedback-id: i76984098:Fastmail
In-reply-to: <e7534f4d-489f-e29f-9932-834853445814@fduerr.de>
References: <e7534f4d-489f-e29f-9932-834853445814@fduerr.de>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.14.0

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 asexpected is not used in 15.3.


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


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- PgSQL 15.3: Execution plan not using index as expected
  - From: Dürr Software

Prev by Date: How to set default privilege for new users to have no access to other databases?
Next by Date: Re: How to set default privilege for new users to have no access to other databases?
Previous by thread: PgSQL 15.3: Execution plan not using index as expected
Next by thread: Re: PgSQL 15.3: Execution plan not using index as expected
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux