Re: O(n^2) aggregates - Mailing list pgsql-hackers

Hello

>
> select count(*)
>   from huge
>  where h = any ((select arrayize( (1+random()*300000000)::integer )
>                   from generate_series(1,1000)
>                 )::integer[])
>

select array(select (1+random()*300000000):: integer from
generate_series(1,40000));
Time: 111,807 ms