Re: An unresolved performance problem.

On Fri, 9 May 2003, Tom Lane wrote:

> >> 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?

The index is defined as:

status_all btree (assettable, assetidval, appname, apptblname, status,
isvalid)

And correlations are:

  attname   | correlation
-------------+-------------
 assettable  |           1
 assetidval  |    0.125902
 appname     |    0.942771
 apptblname  |    0.928761
 status      |    0.443405
 isvalid     |    0.970531

>
>             regards, tom lane
>

--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill@matrix.gatewaynet.com
        mantzios@softlab.ece.ntua.gr