Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Date
Msg-id 2839.1297799537@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5887: EXPLAIN returns more than 1000 rows when table is empty  ("Nick Baryshnikov" <Warstone@list.ru>)
Responses Re[2]: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty  (Warstone@list.ru <warstone@list.ru>)
List pgsql-bugs
Tree view 
"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 by date:

Previous
From: "Nick Baryshnikov"
Date:
Subject: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty
Next
From: Warstone@list.ru
Date:
Subject: Re[2]: BUG #5887: EXPLAIN returns more than 1000 rows when table is empty