Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cocmL-0006yz-U9 for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Mar 2017 21:17:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cocmL-0007vS-Gd for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Mar 2017 21:17:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cocmK-0007th-S3 for pgsql-bugs@postgresql.org; Thu, 16 Mar 2017 21:17:48 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cocmI-0006jl-A7 for pgsql-bugs@postgresql.org; Thu, 16 Mar 2017 21:17:48 +0000 Received: from [192.168.127.3] (port=11782 helo=isig.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1cocmH-000Hjq-4w; Thu, 16 Mar 2017 21:17:45 +0000 Received: from localhost ([127.0.0.1]:33990 helo=isig.riddles.org.uk) by isig.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1cocmG-0004Q8-9a; Thu, 16 Mar 2017 21:17:44 +0000 From: Andrew Gierth To: Andres Freund Cc: pgsql-bugs@postgresql.org Subject: Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples In-Reply-To: <20170316210802.ioaflzbc3igkk2nc@alap3.anarazel.de> (Andres Freund's message of "Thu, 16 Mar 2017 14:08:02 -0700") Message-ID: <87zigkj543.fsf@news-spur.riddles.org.uk> References: <20160331103739.8956.94469@wrigleys.postgresql.org> <20160331104129.GG23562@awork2.anarazel.de> <87y3w53est.fsf@news-spur.riddles.org.uk> <20170316203750.d5hyt3vp33hzxlxa@alap3.anarazel.de> <874lytj697.fsf@news-spur.riddles.org.uk> <20170316210802.ioaflzbc3igkk2nc@alap3.anarazel.de> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Thu, 16 Mar 2017 21:17:43 +0000 MIME-Version: 1.0 Content-Type: text/plain X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org >>>>> "Andres" == Andres Freund 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