> Description: Optimizer does not use function-based index for an order
> Subject line says it all.
The optimizer makes an educated guess about whether to use indexes or
not. Without more information it's impossible to second-guess it.
You might want to ask on pgsql-general for advice on whether it's
making a good choice and how to influence it. But you'll have to
provide more information such as the actual schema and explain plans
of with and without enable_sort or enable_seqscan disabled.
Also 8.2 came out two years ago, if you're just starting with Postgres
you might as well use 8.4 which has features which will make this
easier -- including the ability to tell the planner how expensive your
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2009-08-20 22:40:10|
|Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . . |
|Previous:||From: Brian Ceccarelli||Date: 2009-08-20 20:30:56|
|Subject: BUG #5000: Optimizer does not use function-based index for an order by|