RE: Access plan selection logic PG9.2 -> PG14

From: "Ryo Yamaji (Fujitsu)" <yamaji(dot)ryo(at)fujitsu(dot)com>
To: 'Adrian Klaver' <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: Access plan selection logic PG9.2 -> PG14
Date: 2023-09-15 09:29:45
Message-ID: TYAPR01MB6073C17B86AE4005DF5316178AF6A@TYAPR01MB6073.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

on Fri, 15 Sept 2023 at 0:00, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2023-09-15 09:50:08 Re: Access plan selection logic PG9.2 -> PG14
Previous Message Ryo Yamaji (Fujitsu) 2023-09-15 09:13:30 RE: Access plan selection logic PG9.2 -> PG14