pgsql: Improve patternsel() by applying the operator itself to each

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve patternsel() by applying the operator itself to each
Date: 2006-01-10 17:35:53
Message-ID: 20060110173553.E5A049DC865@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Improve patternsel() by applying the operator itself to each value
listed in the column's most-common-values statistics entry. This gives
us an exact selectivity result for the portion of the column population
represented by the MCV list, which can be a big leg up in accuracy if
that's a large fraction of the population. The heuristics involving
pattern contents and prefix are applied only to the part of the population
not included in the MCV list.

Modified Files:
--------------
pgsql/src/backend/utils/adt:
selfuncs.c (r1.194 -> r1.195)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.194&r2=1.195)

Browse pgsql-committers by date

  From Date Subject
Next Message User Gsmet 2006-01-10 17:52:06 pgfouine - pgfouine: commited the current work to work on 0.2 branch
Previous Message User H-saito 2006-01-10 05:06:16 psqlodbc - psqlodbc: [07.03.0258] up the Version number.