Re: An unresolved performance problem.

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: An unresolved performance problem.
Date: 2003-05-09 19:25:12
Message-ID: Pine.LNX.4.44.0305091721310.7304-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance pgsql-sql


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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2003-05-11 13:14:49 failed compile csv version PostgreSQL
Previous Message Achilleus Mantzios 2003-05-09 19:13:59 Re: An unresolved performance problem.

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Siegel 2003-05-10 15:25:16 realtime data inserts
Previous Message Achilleus Mantzios 2003-05-09 19:13:59 Re: An unresolved performance problem.

Browse pgsql-sql by date

  From Date Subject
Next Message Lucas Lain 2003-05-09 21:05:45 epoch to timestamp
Previous Message Achilleus Mantzios 2003-05-09 19:13:59 Re: An unresolved performance problem.