pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-bugs@postgresql.org
Subject: Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples
Date: Thu, 16 Mar 2017 21:17:43 +0000
Message-ID: <87zigkj543.fsf@news-spur.riddles.org.uk> (raw)
In-Reply-To: <20170316210802.ioaflzbc3igkk2nc@alap3.anarazel.de>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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



view thread (10+ messages)  latest in thread

Message-ID: <87zigkj543.fsf@news-spur.riddles.org.uk>
Permalink:  ../87zigkj543.fsf@news-spur.riddles.org.uk/
Also on:    postgresql.org/message-id/87zigkj543.fsf@news-spur.riddles.org.uk

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: andrew@tao11.riddles.org.uk, andres@anarazel.de
  Subject: Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples
  In-Reply-To: <87zigkj543.fsf@news-spur.riddles.org.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox