Justin Pryzby <pry...@telsasoft.com> writes: > On Fri, Nov 10, 2017 at 04:19:41PM -0500, Tom Lane wrote: >> One idea is to say that relpages = reltuples = 0 is only the state that >> prevails for a freshly-created table, and that VACUUM or ANALYZE should >> always set relpages to at least 1 even if the physical size is zero.
>> Dunno if that would confuse people. > What about adding && rel->rd_rel->reltuples==0, and make VACUUM/ANALYZE > instead > set only reltuples=1, since that's already done at costsize.c: clamp_row_est() > and therefor no additional confusion? 1 tuple in 0 pages is a physically impossible situation, so I'm quite sure that way *would* confuse people. regards, tom lane -- Sent via pgsql-performance mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance