On Sun, Feb 4, 2018 at 8:19 AM, legrand legrand <legrand_legrand@xxxxxxxxxxx> 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.
