Re: slow array(subselect)

2018-03-04 Thread Pavel Stehule
2018-03-04 21:36 GMT+01:00 Tomas Vondra : > > > On 03/04/2018 09:19 PM, Pavel Stehule wrote: > > Hi > > > > Just curious > > > > postgres=# explain analyze select array_upper(array_agg(i),1) from > > generate_series(1,10) g(i); > >QUE

Re: slow array(subselect)

2018-03-04 Thread Tomas Vondra
On 03/04/2018 09:19 PM, Pavel Stehule wrote: > Hi > > Just curious > > postgres=# explain analyze select array_upper(array_agg(i),1) from > generate_series(1,10) g(i); >    QUERY > PLAN