POSTGRESQL Optimizer

From: Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr>
To: pgsql-general(at)postgresql(dot)org
Subject: POSTGRESQL Optimizer
Date: 2002-06-21 12:45:11
Message-ID: Pine.GSO.4.44.0206211535420.22580-100000@amorgos.csd.uch.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)csd(dot)uch(dot)gr)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tycho Fruru 2002-06-21 13:01:02 Re: POSTGRESQL Optimizer
Previous Message Andrew Sullivan 2002-06-21 12:25:54 Re: SELECT problem