Andrew Snow <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
