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

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples
Date: 2017-03-16 21:17:43
Message-ID: 87zigkj543.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Andres" == Andres Freund <andres(at)anarazel(dot)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)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-03-16 21:28:24 Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples
Previous Message Andres Freund 2017-03-16 21:08:02 Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples