Allen Landsidel <alandsidel@xxxxxxxxx> 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