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

From: Warstone(at)list(dot)ru <warstone(at)list(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re[2]: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Date: 2011-02-15 20:59:58
Message-ID: E1PpS06-0002ER-00.warstone-list-ru@f13.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us>:

> "Nick Baryshnikov" <Warstone(at)list(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Maxim Boguk 2011-02-16 09:24:16 Re: BUG #5885: Strange rows estimation for left join
Previous Message Tom Lane 2011-02-15 19:52:17 Re: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty