Christian Schröder wrote:
> I think it is my job as db admin to make the database work the way my users
> need it, and not the user's job to find a solution that fits the database's
> needs ...
>
> Is there really nothing that I can do?
You can improve the selectivity estimator function. One idea is that if
you are storing something that's not really a general character string,
develop a specific datatype, with a more precise selectivity estimator.
If you are you up to coding in C, that is.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support