Postgres Pro
Downloads
Home   >   mailing lists

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

From Achilleus Mantzios
Subject Re: An unresolved performance problem.
Date
Msg-id Pine.LNX.4.44.0305091721310.7304-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: An unresolved performance problem.  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-performance
Tree view 
I changed
*indexCorrelation = varCorrelation / nKeys;
to
*indexCorrelation = varCorrelation ;

and i got cost=28.88
and it beats every other index.


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

pgsql-performance by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: An unresolved performance problem.
Next
From: Ericson Smith
Date:
Subject: Re: [GENERAL] realtime data inserts