From: | "Zeugswetter Andreas DCP SD" <ZeugswetterA(at)spardat(dot)at> |
---|---|
To: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: LIKE, leading percent, bind parameters and indexes |
Date: | 2006-05-24 08:22:16 |
Message-ID: | E1539E0ED7043848906A8FF995BDA579010E9369@m0143.s-mxs.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> AFAICS the problem is not restricted to LIKE, we can easily find a lot
of
> similar problems caused by the actual parameters. For example, SeqScan
vs.
> IndexScan vs. BitmapIndexScan for a range query. So an improvement is
> definitely needed.
> Another way is to generate a plan on the fly. What we do is to let
some
> REPLAN nodes sit on top of some critical plan node: at the execution,
we
> will compare the actual numbers we get and the estimated number we
have
Since we are deciding this on histogram data, it seems we could "store"
the ranges (and exception values) where this plan is not good, and
replan in
case the new value does not fit.
This would also imply, that we postpone (part of the) planning until we
get the
first values, when the node cost largly depends on the supplied value.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | sibel karaasma | 2006-05-24 08:46:19 | compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!! |
Previous Message | Hannu Krosing | 2006-05-24 08:17:57 | Re: error-free disabling of individual child partition |