Re: Row estimates on empty table - Mailing list pgsql-general

From Tom Lane
Subject Re: Row estimates on empty table
Date
Msg-id 4488.1253223585@sss.pgh.pa.us
Whole thread Raw
In response to Row estimates on empty table  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
Alban Hertroys <dalroi@solfertje.student.utwente.nl> 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.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 'Weird' errors
Next
From: Tom Lane
Date:
Subject: Re: haversine formula with postgreSQL