POSTGRESQL Optimizer

On Fri, 2002-06-21 at 14:45, Tourtounis Sotiris wrote:

I wonder how i can enforce the PostgreSQL optimizer in order to use the
indexes in cases of SQL queries with comparison (<,>) and not equality. I
create a table with 4 attributes, the two of them are types of integer8 in
PostgreSQL and i create to those 2 indexes (which by default are B+trees).
However they didn't work. I would appreciate any comment.

try

select * from foo where bar > '12345';

insted of

select * from foo where bar > 12345;

did you vacuum analyze before ?

Cheers
Tycho

--
Tycho Fruru tycho@fruru.com
"Prediction is extremely difficult. Especially about the future."
- Niels Bohr