From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Geoghegan <pg@bowt.ie>
cc: Sajith Prabhakar Shetty <ssajith@blackduck.com>,
        Andrei Lepikhov <lepihov@gmail.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>,
        Todd Cook <cookt@blackduck.com>
Subject: Re: Postgres: Queries are too slow after upgrading to PG17 from PG15
In-reply-to: <2532876.1754096999@sss.pgh.pa.us>
References: 
 <PH7PR19MB6481278D3A55C8BD04B9B9EDB590A@PH7PR19MB6481.namprd19.prod.outlook.com>
 <2a8243eb-a8e8-4c2d-9c46-7152782d84f8@gmail.com>
 <DM4PR19MB64869049D2AD4882D114BB90B551A@DM4PR19MB6486.namprd19.prod.outlook.com>
 <CAH2-WzmBXPLn=j+nqwGtzoQiMzjY=otTt1irzb39+NkfnHMsnw@mail.gmail.com>
 <DM4PR19MB6486B947E5F0D800127897F5B551A@DM4PR19MB6486.namprd19.prod.outlook.com>
 <CAH2-Wzkduf6pevzTfGpXr29SoXb9jH6AxAkbJM-cJo1EU0M57Q@mail.gmail.com>
 <DM4PR19MB648605FF2806007FC55C0AA5B55AA@DM4PR19MB6486.namprd19.prod.outlook.com>
 <CAH2-WznCkB0V86y+OO0_pp2NfS14-gM2FbMr9uXx9yjdQkpbxQ@mail.gmail.com>
 <DM4PR19MB6486E73FF04BADFD120A0568B525A@DM4PR19MB6486.namprd19.prod.outlook.com>
 <CAH2-WzmNhY2HWNkPku0ugesSp=AxWyy+9tCaq4YqNMSRV8QDqw@mail.gmail.com>
 <2121299.1753993453@sss.pgh.pa.us>
 <CAH2-Wz=O3C=9EWu1azGuHT-3iz1jOon21vG53xFfwJhiaG2CFg@mail.gmail.com>
 <2128451.1753997128@sss.pgh.pa.us>
 <CAH2-WzmOOBV7wtu3K6R_zO105Qi_BE-2Ki5T9KLsHETP=GQwAA@mail.gmail.com>
 <CAH2-Wzn_dX8c14x0-7DpPhE+wBcMAmbBjJ0yA!
 ! s-ir30Z3zdUPw@mail.gmail.com> <2532876.1754096999@sss.pgh.pa.us>
Comments: In-reply-to Tom Lane <tgl@sss.pgh.pa.us>
	message dated "Fri, 01 Aug 2025 21:09:59 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2538940.1754100308.1@sss.pgh.pa.us>
Date: Fri, 01 Aug 2025 22:05:08 -0400
Message-ID: <2538941.1754100308@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2538941.1754100308%40sss.pgh.pa.us>
Precedence: bulk

I wrote:
> My thought here is that there is not a lot you can do in v17: it's
> been out for a year and we dare not destabilize it.  Take the easy
> near-guaranteed win and be happy.  Additional improvements can be
> pursued at our leisure in the master branch.

Also, the calendar is a factor here: we are only a week away from
release freeze for the August releases.  Even if you're feeling
optimistic about what we could risk in v17 with some development
effort, I'd counsel first working on a minimal patch that would
be safe to apply on short notice, so we can get the easy win
in this release cycle.

			regards, tom lane