Re[2]: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty

Поиск
Список
Период
Сортировка
От Warstone@list.ru
Тема Re[2]: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Дата
Msg-id E1PpS06-0002ER-00.warstone-list-ru@f13.mail.ru
обсуждение исходный текст
Ответ на Re: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Список pgsql-bugs
Understood. Can you show me where it is written in the documentation?
(I just want to know is, whether it is in the documentation and if not, probably should add this case)

Tue, 15 Feb 2011 14:52:17 -0500 письмо от Tom Lane <tgl@sss.pgh.pa.us>:

> "Nick Baryshnikov" <Warstone@list.ru> writes:
> > Description:        EXPLAIN returns more than 1000 rows when table is empty
>
> This is not a bug; it's intentional behavior.  As long as the recorded
> size of the table is zero, the planner assumes that information is
> probably obsolete.
>
> regards, tom lane



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

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