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

2011-03-03 Thread Robert Haas
On Tue, Feb 15, 2011 at 3:59 PM, warst...@list.ru wrote: > 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) This is a pretty frequently asked question, so it might be w

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

2011-02-15 Thread Warstone
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 : > "Nick Baryshnikov" writes: > > Description:EXPLAIN returns

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

2011-02-15 Thread Tom Lane
"Nick Baryshnikov" 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, t

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

2011-02-15 Thread Nick Baryshnikov
The following bug has been logged online: Bug reference: 5887 Logged by: Nick Baryshnikov Email address: warst...@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 TAB