Re: Chaotic query planning ?

From: Philippe Ivaldi <pivaldi(at)ovya(dot)fr>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Subject: Re: Chaotic query planning ?
Date: 2017-01-30 08:24:11
Message-ID: 87r33l6jmc.fsf@piprime.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Albe Laurenz wrote

> […]
> Experiment with raising join_collapse_limit and from_collapse_limit to 11.

Thank you, this solve the problem.

> Alternatively, optimize the join order by hand and don't tune the parameters.

What is surprising is that there is no apparent/logical optimal strategy.

Best regards,
--
PI

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Steele 2017-01-31 15:20:18 Re: Backup taking long time !!!
Previous Message Vucomir Ianculov 2017-01-28 10:03:55 Re: pgsql connection timeone