Allen Landsidel <alandsidel@gmail.com> writes:
> On Thu, 11 Nov 2004 16:41:51 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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.
> 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