Re: the index on INTEGER field does not work (PG 7.1.2) - Mailing list pgsql-bugs

Andrew Snow <andrew@modulus.org> writes:
> Please see FAQ 4.9

While that's a good answer in general, the default statistics are set up
(with malice aforethought) to give index scans.

regression=# create table test_int(id int primary key);
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'test_int_pkey' for table 'test_int'
CREATE
regression=# explain SELECT * FROM test_int WHERE id = 33;
NOTICE:  QUERY PLAN:

Index Scan using test_int_pkey on test_int  (cost=0.00..8.14 rows=10 width=4)

EXPLAIN

So I'm not sure what's going on here.  Alexandr, what do you get from
EXPLAIN for your queries?

            regards, tom lane