Row estimate on empty tables

Started by Michael Lewisover 4 years ago2 messagesgeneral
Jump to latest
#1Michael Lewis
mlewis@entrata.com

ref:
/messages/by-id/9772.1510348781@sss.pgh.pa.us

This functionality hasn't changed in the years since this post, right? I'm
dealing with temp tables specifically, but seem to be getting bit by this
behavior occasionally so I would like to confirm.

*Michael Lewis | Database Engineer*
*Entrata*

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Michael Lewis (#1)
Re: Row estimate on empty tables

Michael Lewis <mlewis@entrata.com> writes:

ref:
/messages/by-id/9772.1510348781@sss.pgh.pa.us
This functionality hasn't changed in the years since this post, right? I'm
dealing with temp tables specifically, but seem to be getting bit by this
behavior occasionally so I would like to confirm.

We did improve matters in v14, see

https://git.postgresql.org/gitweb/?p=postgresql.git&amp;a=commitdiff&amp;h=3d351d916

(It looks like the v14 release notes say nothing about this, which perhaps
was a bad idea.)

regards, tom lane