Postgres Pro
Downloads
Home   >   mailing lists

RE: Access plan selection logic PG9.2 -> PG14 - Mailing list pgsql-general

From Ryo Yamaji (Fujitsu)
Subject RE: Access plan selection logic PG9.2 -> PG14
Date
Msg-id TYAPR01MB6073C17B86AE4005DF5316178AF6A@TYAPR01MB6073.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Access plan selection logic PG9.2 -> PG14  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
on Fri, 15 Sept 2023 at 0:00, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> Why not just run ANALYZE on the new 14.7 instance?

The statistics were manually updated to fix the access plan.
I was trying to see if I could fix the access plan in a similar way in 9.2 -> 14.7.

I probably will run ANALYZE soon because I haven't been able to achieve the access plan I want.


Regards, Ryo

pgsql-general by date:

Previous
From: "Ryo Yamaji (Fujitsu)"
Date:
Subject: RE: Access plan selection logic PG9.2 -> PG14
Next
From: David Rowley
Date:
Subject: Re: Access plan selection logic PG9.2 -> PG14