Re: [BUGS] BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: [BUGS] BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples
Date
Msg-id 87zigkj543.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: [BUGS] BUG #14057: vacuum setting reltuples=0 for tables with >0tuples  (Andres Freund <andres@anarazel.de>)
Responses Re: [BUGS] BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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)


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: [BUGS] BUG #14057: vacuum setting reltuples=0 for tables with >0tuples
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples