Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE
Date
Msg-id 775999.1745848757@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE  (marcos sicat <marcos.sicat@atlasifs.com>)
Responses Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE
List pgsql-bugs
Tree view 
marcos sicat <marcos.sicat@atlasifs.com> writes:
> The function is the same between v15 and v17.  Is there a subtle difference in performance for nested subqueries in
v17?

Your next step should be to compare the plans for the function's
query.  The auto_explain or pg_stat_statements extensions could
be used to check that in-situ, if manually EXPLAINing that query
doesn't yield insight.

            regards, tom lane

pgsql-bugs by date:

Previous
From: marcos sicat
Date:
Subject: Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE
Next
From: marcos sicat
Date:
Subject: Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE