John A Meinel <john@arbash-meinel.com> writes:
> I am a little surprised that it is taking 40s to scan only 400k rows,
> though.
Yeah, that seemed high to me too. Table bloat maybe? It would be
interesting to look at the output of "vacuum verbose test" to see
how much dead space there is.
regards, tom lane