index on int8 type

From: "Keith L(dot) Musser" <kmusser(at)idisys(dot)com>
To: "PGSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: index on int8 type
Date: 2000-10-12 16:49:01
Message-ID: 000701c0346c$65eb0fb0$0201a8c0@quantum.idisys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When I create a table with INT8 as the type of the primary key field,
PGSQL still uses sequential scans on the table when I select by primary
key.

I currently have version 6.5.3.

Does version 7.0.2 allow indexing on INT8 types?

Keith L. Musser
Integrated Dynamics, Inc.
812-371-7777
email: kmusser(at)idisys(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christophe Boggio 2000-10-12 17:07:15 Re[2]: Comments on earlier age() post.
Previous Message Bruce Momjian 2000-10-12 16:48:00 Re: postgresql 7.1