Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b32Al-0006P4-OY for pgsql-hackers@arkaria.postgresql.org; Wed, 18 May 2016 14:10:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b32Al-0006j7-Bc for pgsql-hackers@arkaria.postgresql.org; Wed, 18 May 2016 14:10:03 +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 1b32Aj-0006ec-5Z for pgsql-hackers@postgresql.org; Wed, 18 May 2016 14:10:01 +0000 Received: from 104-190-1-44.lightspeed.sndgca.sbcglobal.net ([104.190.1.44] helo=joeconway.com) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b32Af-0007nj-GK for pgsql-hackers@postgresql.org; Wed, 18 May 2016 14:10:00 +0000 Received: from [137.122.64.8] (account jconway@joeconway.com HELO [10.65.211.122]) by joeconway.com (CommuniGate Pro SMTP 6.1.4) with ESMTPSA id 16469109; Wed, 18 May 2016 07:09:54 -0700 Subject: Re: Reviewing freeze map code To: Victor Yegorov , Robert Haas References: <20160517193208.GA169606@alvherre.pgsql> <573B8E6E.1070909@2ndquadrant.fr> <142e516d-2b66-1859-6733-aabd6ab9a272@archidevsys.co.nz> <648c400e-ff35-3f95-69cb-4a83f0158e7f@pgmasters.net> <573C714D.2060505@commandprompt.com> Cc: "pgsql-hackers@postgresql.org" From: Joe Conway Openpgp: id=4EA5B4659ED59CC9538139A5332B7E68B699434A Message-ID: <573C77AF.8030201@joeconway.com> Date: Wed, 18 May 2016 10:09:51 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.2 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="XP94to3AQF273A9iLOrDenGFchUJps70b" X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --XP94to3AQF273A9iLOrDenGFchUJps70b From: Joe Conway To: Victor Yegorov , Robert Haas Cc: "pgsql-hackers@postgresql.org" Message-ID: <573C77AF.8030201@joeconway.com> Subject: Re: [HACKERS] Reviewing freeze map code References: <20160517193208.GA169606@alvherre.pgsql> <573B8E6E.1070909@2ndquadrant.fr> <142e516d-2b66-1859-6733-aabd6ab9a272@archidevsys.co.nz> <648c400e-ff35-3f95-69cb-4a83f0158e7f@pgmasters.net> <573C714D.2060505@commandprompt.com> In-Reply-To: Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 On 05/18/2016 09:55 AM, Victor Yegorov wrote: > 2016-05-18 16:45 GMT+03:00 Robert Haas >: >=20 > No, that's what the existing FREEZE option does. This new option is > about unnecessarily vacuuming pages that don't need it. The > expectation is that vacuuming all-frozen pages will be a no-op. >=20 >=20 > VACUUM (INCLUDING ALL) ? VACUUM (FORCE ALL) ? Joe --=20 Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development --XP94to3AQF273A9iLOrDenGFchUJps70b Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iQIcBAEBAgAGBQJXPHevAAoJEDfy90M199hlrJ4P/33IsPSTqx8PEd12KMRTbGba TYRawD6O6fCIQYRjJBfzkrSgD5qxqJXSjX9bCodkt+pYEZixlheOLGn0iU0XXdhR 3sbv6nYvWLWibDVWIXeeEHLfjYkN58WC5G9xiQ3kZLHN5xpV8yLsUWPr1i9JOG8D FLPSEM1/GGis56EAfZ+Vf/1vqLhuPj4QEGBqq7cBvJ/BgNcXsFRJ9XEIlAhyD8tG gm/ySFuvnDGADlACAQijbGN7PM17t2WO8yG97drnr2Yx/aU5P6kXoN7ivXc7xfmV Tn6wqU1Xwm5uTJ3LPP249N+spc/yLd6G8SXeoaRoLzrNlTPeRrmbLvTsrey+stZ4 d0xEOAF5/aGoJ59jUH6kystalV0Un+WBBQzMm8SHmsklXnFGchU5o2S1zGIxHZYo kdUIzbhL+yg7rF9BbG/Nl9D0dIgBg6O1d5iaOjHTgT4VwY7ci637jxwHAYsf+t0J IQvlaVqpbqDNbnyiuI9O063R/UaV2Ce/t+491oqLA+nx8/4RfuN9mKwQt8NMYSeT WuaPaxsDrS296T4q1iOpJDziJffOHlorh58DOxCJ3MlN8Vj+pai8CLBnM/JkTDUM ShyX2WDm8FRyph81PqintcMQL/4ku3zcT1RZGveucZBlzHRGr1c0ZHJdIqKm40UK jRH0o+ceHP9oi734EuSJ =6/Od -----END PGP SIGNATURE----- --XP94to3AQF273A9iLOrDenGFchUJps70b--