Allen Landsidel <alandsidel@gmail.com> writes:
> Clustering is really unworkable in this situation.
Nonetheless, please do it in your test scenario, so we can see if it has
any effect or not.
The speed you're getting works out to about 7.2 msec/row, which would be
about right if every single row fetch caused a disk seek, which seems
improbable unless the table is just huge compared to your available RAM.
regards, tom lane