Re: Weird behaviour of the planner

2018-08-01 Thread Guillaume Lelarge
2018-08-01 16:59 GMT+02:00 David Rowley : > On 2 August 2018 at 02:48, Guillaume Lelarge > wrote: > > EXPLAIN (ANALYZE) SELECT DISTINCT * FROM gleu2; > > > >QUERY PLAN > > > --

Re: Weird behaviour of the planner

2018-08-01 Thread David Rowley
On 2 August 2018 at 02:48, Guillaume Lelarge wrote: > EXPLAIN (ANALYZE) SELECT DISTINCT * FROM gleu2; > >QUERY PLAN > - > Uni

Weird behaviour of the planner

2018-08-01 Thread Guillaume Lelarge
Hi, While working on a slow query of one of our customers, I found this behaviour which seems quite weird to me. Here it is: (no changes on any parameter) EXPLAIN (ANALYZE) SELECT DISTINCT * FROM gleu2; QUERY PLAN ---