From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sajith Prabhakar Shetty <ssajith@blackduck.com>
cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: Postgres: Queries are too slow after upgrading to PG17 from PG15
In-reply-to: 
 <DM4SPRMB00127B778BCB2A2032AFF420B590A@DM4SPRMB0012.namprd19.prod.outlook.com>
References: 
 <PH7PR19MB6481278D3A55C8BD04B9B9EDB590A@PH7PR19MB6481.namprd19.prod.outlook.com>
 <11970.1747323991@sss.pgh.pa.us>
 <DM4SPRMB00127B778BCB2A2032AFF420B590A@DM4SPRMB0012.namprd19.prod.outlook.com>
Comments: In-reply-to Sajith Prabhakar Shetty <ssajith@blackduck.com>
	message dated "Thu, 15 May 2025 16:21:10 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <16973.1747399903.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 16 May 2025 08:51:43 -0400
Message-ID: <16974.1747399903@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/16974.1747399903%40sss.pgh.pa.us>
Precedence: bulk

Sajith Prabhakar Shetty <ssajith@blackduck.com> writes:
> In my first test, I used pg_upgrade to upgrade the instance from 15 to 1=
7, and in my second test, I created PG15 and PG17 separately from brew rep=
o, I don=E2=80=99t think I am using debug build here.

Might be worth checking the brew recipes... it's common for packagers to
set the debug option for beta versions, and I could believe that whoever
packages PG for HomeBrew forgot to take that out again for 17.0.

But, assuming it's not that, could you put together a self-contained
test case that demos what you're seeing?

			regards, tom lane