Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Chaotic query planning ? - Mailing list pgsql-performance

From Philippe Ivaldi
Subject Re: [PERFORM] Chaotic query planning ?
Date
Msg-id 87r33l6jmc.fsf@piprime.fr
Whole thread Raw
In response to Re: [PERFORM] Chaotic query planning ?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Vucomir Ianculov
Date:
Subject: Re: [PERFORM] pgsql connection timeone
Next
From: David Steele
Date:
Subject: Re: [PERFORM] Backup taking long time !!!