Allen Landsidel <alandsidel@xxxxxxxxx> writes: > On Thu, 11 Nov 2004 16:41:51 -0500, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> 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. > It did not, not enough to measure anyway, which does strike me as > pretty odd. Me too. Maybe we are barking up the wrong tree entirely, because I really expected to see a significant change. Lets start from first principles. While you are running this query, what sort of output do you get from "vmstat 1"? I'm wondering if it's I/O bound or CPU bound ... regards, tom lane
