On Jan 23, 2019, at 6:46 AM, Tom Lane wrote:
>
> Oleksandr Shulgin writes:
>> On Wed, Jan 23, 2019 at 9:44 AM Donald Dong wrote:
>>> 1. Enumerate all the plans
>
>> So enumerating all possible plans stops being practical for even slightly
>> complicated queries.
>
> Yes. You can *not* disabl
Oleksandr Shulgin writes:
> On Wed, Jan 23, 2019 at 9:44 AM Donald Dong wrote:
>> 1. Enumerate all the plans
> So enumerating all possible plans stops being practical for even slightly
> complicated queries.
Yes. You can *not* disable the planner's aggressive pruning of losing
paths and subpat
On Wed, Jan 23, 2019 at 9:44 AM Donald Dong wrote:
>
> 1. Enumerate all the plans
>
Not sure this is going to work. Because of the total number of possible
plans is somewhere
around O(n!), if I'm not mistaken, in terms of number of joined relations
times the available
access methods times the p
