Am 21.11.2003 um 06:54 schrieb Tom Lane:
Martin Hampl <[EMAIL PROTECTED]> writes:Index Scan using word_lower_idx on token (cost=0.00..98814.08 rows=25382 width=16) Index Cond: (lower((word)::text) = 'saxophone'::text)
The rows estimate (and therefore also the cost estimate) is a complete
guess in this situation, because the system keeps no statistics about
the values of lower(word). Improving this situation is on the TODO list.
Thanks a lot for your answer.
Any idea about when this situation will be improved? Until then I have to find a work around... any suggestions?
Regards, Martin.
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
