Re: postgresql 10.1 wrong plan in when using partitions bug

On Sun, Feb 4, 2018 at 8:19 AM, legrand legrand <legrand_legrand@hotmail.com
> wrote:

> What is the value of guc constrain_exclusion ?
>
>
>
In my use case, which is a big union all behind a view, setting this to
off, on, or partition makes no difference.  It still sequence scans all of
the sub-tables in pg 10.1 whereas it used the indexes in 9.6.