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