Re: [GENERAL] How to force the parser to use index scan instead of

2006-10-07 Thread Ron Johnson
-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

Re: [GENERAL] How to force the parser to use index scan instead of sequential scan

2006-10-07 Thread Jaime Casanova
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