Re: Recursive query slow on strange conditions

You can also send a link to the plan on https://explain.depesz.com/ Which maybe more people will look at than if it requires downloading and restoring a DB. Thanks for the advice. Here is the plan for PG 11.6 : https://explain.depesz.com/s/Ewt8 And the one for PG 12.2 : https://explain.depesz.c

Re: Recursive query slow on strange conditions

På mandag 27. april 2020 kl. 20:10:34, skrev Justin Pryzby < pry...@telsasoft.com >: On Mon, Apr 27, 2020 at 07:49:50PM +0200, Jean-Christophe Boggio wrote: > I have a performance/regression problem on a complicated query (placed into > a function) when some tables

Re: Recursive query slow on strange conditions

On Mon, Apr 27, 2020 at 07:49:50PM +0200, Jean-Christophe Boggio wrote: > I have a performance/regression problem on a complicated query (placed into > a function) when some tables are empty. > I first sent a message to the pgsql-bugs mailing list : > https://www.postgresql.org/message-id/16390-e9

Recursive query slow on strange conditions

Hello, I have a performance/regression problem on a complicated query (placed into a function) when some tables are empty. On Pg 11.6 the query takes 121ms On Pg 12.2 it takes 11450ms I first sent a message to the pgsql-bugs mailing list : https://www.postgresql.org/message-id/16390-e9866af1