On 11/6/07, Christian Schröder <[EMAIL PROTECTED]> wrote:
> Hi list,
> once again I do not understand how the query planner works and why it
> apparently does not find the best result.
> I have a table with about 125 million rows. There is a char(5) column
> with a (non-unique) index. When I try to
It may depend on the index itself against the locales.
1. define the insex with the text_pattern_ops operato class
2. run vacuum analyze on the table
3. re-run the explain
See chapter 11 (especiallu 11.8) for v8.2
Il Tuesday 06 November 2007 16:25:09 Christian Schröder ha scritto:
> Hi list,
>
Hi list,
once again I do not understand how the query planner works and why it
apparently does not find the best result.
I have a table with about 125 million rows. There is a char(5) column
with a (non-unique) index. When I try to find the distinct values in
this column using the following sql