Sajith Prabhakar Shetty <ssajith@blackduck.com> writes:
> Now surprisingly one of the query i took from application which used to execute in 2s in PG15, is now taking 1min+ in
PG17.
The data you've actually showed us does not back up that complaint.
But I do see a 2x slowdown.
> Explain plan of the two queries almost same, all the joins and paths used are exactly same.
Yeah, that is odd. The only simple explanation I can think of is that you
are using a debug build of v17.
regards, tom lane
