7.1.2 vs. INT8 indexes

From: Michael Graff <explorer(at)flame(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.1.2 vs. INT8 indexes
Date: 2001-06-01 23:32:13
Message-ID: v6ae3rwzcy.fsf@kechara.flame.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


When I create a table with an INT8 member and create an index on it,
a sequential scan is performed on select.

When I use INT, it uses the index.

Is there some trick to make this work, or am I just screwed?

Thanks :)

--Michael

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gerald Gutierrez 2001-06-02 01:21:25 PostgreSQL Replication Server?
Previous Message Peter Eisentraut 2001-06-01 21:04:45 Re: Re: [GENERAL] Compiling to RPM setup/filesystem layout