Postgres Pro
Downloads
Home   >   mailing lists

Re: PgSQL 15.3: Execution plan not using index as expected - Mailing list pgsql-general

From Adrian Klaver
Subject Re: PgSQL 15.3: Execution plan not using index as expected
Date
Msg-id fd6c587b-6694-aeb3-063d-38b3243dc455@aklaver.com
Whole thread Raw
In response to PgSQL 15.3: Execution plan not using index as expected  (Dürr Software <info@fduerr.de>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Ashok Patil
Date:
Subject: Query regarding certificate authentication in postgres
Next
From: "David G. Johnston"
Date:
Subject: Re: How to set default privilege for new users to have no access to other databases?