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

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

2006-10-07 Thread ck
Hello, I am using PostgreSQL 7.3.2. I have a large table in a database , its primary key field is int8. Almost all of my queries are written relaing to that field. That field is B-Tree indexed. When i check the query plan i found that all the queries are using sequential scan and index wa