Re: Postgres: Queries are too slow after upgrading to PG17 from PG15 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgres: Queries are too slow after upgrading to PG17 from PG15
Date
Msg-id 16974.1747399903@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres: Queries are too slow after upgrading to PG17 from PG15  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Sajith Prabhakar Shetty <ssajith@blackduck.com> writes:
> In my first test, I used pg_upgrade to upgrade the instance from 15 to 17, and in my second test, I created PG15 and
PG17separately from brew repo, I don’t 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



pgsql-bugs by date:

Previous
From: 萧鸿骏
Date:
Subject: Re: Re: Re: BUG #18927: Poor query plan - HashAggregate is more than twice as fast but at a higher cost
Next
From: jian he
Date:
Subject: Re: BUG #18923: pg_dump 18beta1 fails to process complex table names