Re: Strange (?) Index behavior? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Strange (?) Index behavior?
Date
Msg-id 6687.1100298900@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange (?) Index behavior?  (Allen Landsidel <alandsidel@gmail.com>)
Responses Re: Strange (?) Index behavior?
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Clarification on two bits on VACUUM FULL VERBOSE output
Next
From: Allen Landsidel
Date:
Subject: Re: Strange (?) Index behavior?