# I took a join to 1000 random numbers as equivalent to 1000 searches: # table hm is the table with the 25GB data loaded into it $ echo "select * from (select (random()*131899400)::int from generate_series(1,1000)) as r(n) join hm on r.n = hm.id;" | psql -q | tail -n 1 Time: 19555.717 ms