Horton

Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples

Andrew Gierth <andrew@tao11.riddles.org.uk>

View thread View on postgr.es
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-bugs@postgresql.org
Date: 2017-03-16T21:17:43Z
Lists: pgsql-bugs 
>>>>> "Andres" == Andres Freund <andres@anarazel.de> writes:

 Andres> Hm, should we prevent autovacuum/analyze from running on the table?

Probably, yes; good point. (Also, I just realized it would speed things
up a bit to change the largely useless second column to a non-toastable
type or remove it so we can avoid having a toast table.)

 Andres> Seems like a good thing to include in the tree.  I'd be ok with
 Andres> just including the simpler version in the relevant branches.

Ok.

-- 
Andrew (irc:RhodiumToad)

Commits

  1. Avoid having vacuum set reltuples to 0 on non-empty relations in the