Re: [GENERAL] Row estimates on empty table

2009-09-17 Thread Tom Lane
Alban Hertroys writes: > I'm seeing something strange with the row-estimates on an empty table. It's intentional that we don't assume an empty table is empty. Otherwise you could get some spectacularly awful plans if you create a table, fill it, and immediately query it.

[GENERAL] Row estimates on empty table

2009-09-17 Thread Alban Hertroys
Hello all, I'm seeing something strange with the row-estimates on an empty table. The table in question is merely a template-table that specialised tables inherit from, it will never contain any data. Nevertheless, after importing my creation script and vacuum analyse the result I see is