Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hCfWi-0006wf-3i for pgsql-hackers@arkaria.postgresql.org; Sat, 06 Apr 2019 07:14:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hCfWf-0001kj-4d for pgsql-hackers@arkaria.postgresql.org; Sat, 06 Apr 2019 07:14:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hCfWe-0001ij-Mz for pgsql-hackers@lists.postgresql.org; Sat, 06 Apr 2019 07:14:04 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hCfWb-0001QP-DD for pgsql-hackers@postgresql.org; Sat, 06 Apr 2019 07:14:03 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id C2D962234B; Sat, 6 Apr 2019 03:14:00 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sat, 06 Apr 2019 03:14:00 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=heLzoeBO1DfqkkaJHy9e680oc5p Xvd1tLD3cIJIwNPU=; b=Zo4xICzPdvC5kw0MhJcq49N8/R2DUn8C1/msnA4U8tE wPr0GsEjPEtO7js/pnP+aS3gJ706XuaHpQ3pQdevCBTFuay5qPYRFD2ygZu43Ddb E4llC6XotTkEpyC6zGwEFEZSyWbXKqUOeZk073t5sAl6Zv8B4AibLeHxbp3S5+jC QLILPSkKNJO5Hxve6b/OnJ67LSiBlxrptwBmAhE3Mx95e2Rjx6PfKfpCtb5WKZSC ZbwfRcM/xW1sOyfK9VuDk1/lOnUR0TLkeJgAm+1or2xxrb4EKYyNTLYQuvGjk6YT l7UfaOmvzm4Z2DloiXp1VlblrPlftLceq0fJ04TN3Sw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=heLzoe BO1DfqkkaJHy9e680oc5pXvd1tLD3cIJIwNPU=; b=wSPw4jMChw9mpoxcS2eifs CJD/W9i+SC+DI2QBfoPXdllTGDoazli92vfB6+GvMWhwX0fAC+afYgcZxnUPwaGn LtgVjonOzFHvd1pJ61ePUcFV+8TK9UsLrokcTtxuYwhJgzV8Rpj+ShCbsDg/CzGf l6OVFJNSHD3kcwURNWYpdox7fPk86sHBy+rOLCGNifqh9yR3paVmsxd+3Ok6oHa/ vt0MJA61lQvDpc/A1oFglo0HR3Jp+UjXBkmigm7Ls5q5nXLkEOz9FOWYl8rxxAnt rlBZvj6hOYNuGnShTwIc26knh3ME2271VgzM4E5+Wvo4zVOusxwZZt9GQSqMrCkA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddrtdekgdduvdegucdltddurdeguddtrddttd dmucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffk fhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrh cuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucfkphepudduuddruddtvddr udektddrudekheenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqh huihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 9DB7DE40E3; Sat, 6 Apr 2019 03:13:56 -0400 (EDT) Date: Sat, 6 Apr 2019 16:13:53 +0900 From: Michael Paquier To: Masahiko Sawada Cc: Andres Freund , Robert Haas , Kyotaro HORIGUCHI , "Bossart, Nathan" , Alvaro Herrera , PostgreSQL-development Subject: Re: New vacuum option to do only freezing Message-ID: <20190406071353.GC2145@paquier.xyz> References: <20190403.131702.71087088.horiguchi.kyotaro@lab.ntt.co.jp> <20190404.091743.76975665.horiguchi.kyotaro@lab.ntt.co.jp> <20190406012335.k54xny5iwclqwvxp@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="JgQwtEuHJzHdouWu" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --JgQwtEuHJzHdouWu Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Apr 06, 2019 at 11:31:31AM +0900, Masahiko Sawada wrote: > Yes, but Fujii-san pointed out that this option doesn't support toast > tables and I think there is not specific reason why not supporting > them. So it might be good to add toast.vacuum_index_cleanup. Attached > patch. Being able to control that option at toast level sounds sensible. I have added an open item about that. -- Michael --JgQwtEuHJzHdouWu Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlyoUbEACgkQnvQgOdby QH2J3A/+PMjz6g1Dz/rZTM0U79/931fDP4zugJANWrLLUfWRzxR8TIdK8wTifqm6 fwN5+OVYMzL3G6nlUg935olro/jRDC+g58UCcQJAyYxmatEE/byxeEFrQeY7FHT9 lM8Va9jBznq7ajADhFw8MZ9z1GigGQ9BsBA6cZgeQCCSmHsmXnsONm53vEyPpFBK CzUo4W6iOP5Ra4x4XlONmLTkjdFeluGan5Z/1nxQToY6HZwpv2UJD8g5931zC1Qb 5q4JAuaN0cIbXJw2OMh8nrDpTxSSb65VBs2BE2bRPmqBpMhojM2PtZj/wJFSpDAL 7LOfjPA4yAQOsqx53KxqPIjfiBmCC7foTj2fiFblr9I5Csk6nbSKIPWv+LQ37uYS 4Z4+HomWaQVX4xG9PkTktMe+6jEPqY5oB/29aHVozELxI9Rq1PXQXRHiaShGIlTT ezy+gKtIWxnzSBF3f51hYFcm5ntjcmiZ08fBn4tzWGXOsUfbGV45LNMwqK3b+yKn 4xbgVQ6qGIAfGKRqlpvO8zqUd3MyEvbU930jsZi7XhTLvjXX+zfvM7oTf2Ty+Gq7 QNl7O3YA+RqujYkJ/bFqhH2mGyDbI5vkbzJnLjx0BYBOOafmKNsxtHsm/3zHVyW7 TaJvWqme7LeocRzEQgSoD9+ejJ23V0j8sqA+mRy5VI8rDNKTHHU= =z94B -----END PGP SIGNATURE----- --JgQwtEuHJzHdouWu--