Re: the index on INTEGER field does not work (PG 7.1.2)

Andrew Snow <andrew(at)modulus(dot)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