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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to