BUG #5887: EXPLAIN returns more than 1000 rows when table is empty

Поиск
Список
Период
Сортировка
От Nick Baryshnikov
Тема BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Дата
Msg-id 201102151722.p1FHMVuc035497@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5887
Logged by:          Nick Baryshnikov
Email address:      Warstone@list.ru
PostgreSQL version: 8.4.7
Operating system:   Ubuntu 10.10
Description:        EXPLAIN returns more than 1000 rows when table is empty
Details:

CREATE TABLE test (
    id bigserial NOT NULL PRIMARY KEY
);
VACUUM FULL ANALYZE test;
EXPLAIN ANALYZE SELECT * FROM test;
INSERT INTO test VALUES (DEFAULT);
VACUUM FULL ANALYZE test;
EXPLAIN ANALYZE SELECT * FROM test;

1-st EXPLAIN give me:
"Seq Scan on test  (cost=0.00..31.40 rows=2140 width=8) (actual
time=0.003..0.003 rows=0 loops=1)"
"Total runtime: 0.040 ms"

2-nd:
"Seq Scan on test  (cost=0.00..1.01 rows=1 width=8) (actual
time=0.004..0.005 rows=1 loops=1)"
"Total runtime: 0.025 ms"

VACUUM FULL ANALYZE didn't works when there is 0 records in the table?

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5885: Strange rows estimation for left join
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty