Postgres Pro
Downloads
Home   >   mailing lists

index on int8 type - Mailing list pgsql-general

From Keith L. Musser
Subject index on int8 type
Date
Msg-id 000701c0346c$65eb0fb0$0201a8c0@quantum.idisys.com
Whole thread Raw
List pgsql-general
Tree view 
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@idisys.com

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgresql 7.1
Next
From: Jean-Christophe Boggio
Date:
Subject: Re[2]: Comments on earlier age() post.