Re: An unresolved performance problem. - Mailing list pgsql-performance

From Tom Lane
Subject Re: An unresolved performance problem.
Date
Msg-id 151.1052485680@sss.pgh.pa.us
Whole thread Raw
In response to Re: An unresolved performance problem.  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: An unresolved performance problem.  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-performance
Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> On Fri, 9 May 2003, Tom Lane wrote:
>> Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
>>> If so, how can one find the correlation between the ordering
>>> of a table and a multicolumn index?
>>
>> Well, it is surely no better than the correlation of the index's
>> first column --- what is that?

> it is 1

Well, that's suggestive, isn't it?  What about the remaining columns?

            regards, tom lane


pgsql-performance by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: An unresolved performance problem.
Next
From: Achilleus Mantzios
Date:
Subject: Re: An unresolved performance problem.