Thread: POSTGRESQL Optimizer

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.



                                                 SWTHRHS TOYRTOYNHS
                                                (tourtoun@csd.uch.gr)

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