Allen Landsidel <[EMAIL PROTECTED]> writes:
> On Thu, 11 Nov 2004 16:41:51 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
>> Allen Landsidel <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
