Hi,
    I'm testing PostgreSQL, version 7.1.2, and I create a table,  test1, with these kind of fields:

CREATE TABLE test1 (
    id integer,
    content varchar
);

with 800.000 records, and a btree index setted on the id field.

I noticed the query uses the index for "=" and "<" operators, but if the value used for the "<" operator is higher (600.000 for example), the query makes a seq scan of the table, and the index never works with the ">" operator. Am I managing the indexes well ?

Thanks for the help.

Ciao Paolo





Paolo Cassago

TalentManager
Milan, Paris, Madrid

Tel: +39 02 83 11 23 1
Fax: +39 02 700 43 99 81
Mob: +39 348 82 155 81


16 Nov 2001 09:05:56 +0000
Paolo Cassago <paolo.cassago@talentmanager.com>
Btree doesn't work with ">" condition


Paolo Cassago wrote:

>Hi,
>    I'm testing PostgreSQL, version 7.1.2, and I create a table,  test1, with these kind of fields:
>
>CREATE TABLE test1 (
>    id integer,
>    content varchar
>);
>
>with 800.000 records, and a btree index setted on the id field.
>
>I noticed the query uses the index for "=" and "<" operators, but if the value used for the "<" operator is higher (600.000 for example), the query makes a seq scan of the table, and the index never works with the ">" operator. Am I managing the indexes well ?
>
Have you run VACUUM ANALYZE lately ?

What does EXPLAIN think of the costs ?

-------------
Hannu


Wed, 21 Nov 2001 00:54:30 +0500
Hannu Krosing <hannu@tm.ee>
Re: Btree doesn't work with ">" condition