-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/07/06 21:10, Jaime Casanova wrote:
> On 6 Oct 2006 22:32:16 -0700, ck <[EMAIL PROTECTED]> wrote:
[snip]
>> index scan, Eg
>> select * from h057 where h057001 = 1142::int8
>> the above query uses index scan
>> select * from h057 where h057001 = 11
On 6 Oct 2006 22:32:16 -0700, ck <[EMAIL PROTECTED]> wrote:
Hello,
I am using PostgreSQL 7.3.2. I have a large table in a
that's very old... you should upgrade at least to 7.3.15
database , its primary key field is int8.
Almost all of my queries are written relaing to that field. Th