The type int8 and the use of indexes

From: nelson(at)radix(dot)com(dot)br
To: pgsql-general(at)postgresql(dot)org
Subject: The type int8 and the use of indexes
Date: 2001-01-25 22:11:53
Message-ID: 980460713.3a70a4a9223fc@gandalf.radix.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I realized that PostgreSQL (7.0.3) optimizer doesn´t use indexes in a query
like "select * from my table where pk=1", where the field pk is of
type int8.
I changed the type to int4, and now it uses the index (a lot faster). I also
tryed changing the type to numeric, with the same results.
Why does it happen? Is there something special with type int8 ???

Thanks,
Nelson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-01-25 23:14:53 Re: The type int8 and the use of indexes
Previous Message nfj 2001-01-25 22:10:06 The type int8 and the use of indexes