Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f243c-0003V2-7l for pgsql-hackers@arkaria.postgresql.org; Sat, 31 Mar 2018 00:07:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f243a-00047a-Bm for pgsql-hackers@arkaria.postgresql.org; Sat, 31 Mar 2018 00:07:42 +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.89) (envelope-from ) id 1f243a-00047Q-4M for pgsql-hackers@lists.postgresql.org; Sat, 31 Mar 2018 00:07:42 +0000 Received: from bay.acenet.us ([173.230.252.50]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f243W-0004de-Ce for pgsql-hackers@postgresql.org; Sat, 31 Mar 2018 00:07:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:MIME-Version:Date:Message-ID:From:Cc:References:To:Subject:Sender :Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=7QdxwkGPSqtigXze/DUF+1aVDu99xyJ0B8C0WjoFBdo=; b=SWrSjYe2L9/PExjZyTvaZg62HV aPl0oV1KqjjqIqrn5lkKkdXffM/OnUKm6mRC2/t7+Zm7Us7MSTZPan1JK3OTcCTiZW/inTlhUZiW3 ImIK83VTVGhITonGLr/fHPt71ftHxJrVj8NLDbLKzMk7QTKHdYaGVfEmk2dY+5JlpysgHYi5cW0di 9B6fq3Cl4xCqJ5eOvBKF4UbjH+jZo3281ynoWM3Gu3nOUnR66oJn16bxr68vVa1SpXHllrE9ml7gR sVWPqEFxVrKix945QtJMtNSX1gFWeQmlvVDOEomVcmuuGcoGyGMMS4ZH0mkEq0pNM/57T70JB8V+8 d3SPFzWg==; Received: from [192.182.57.106] (port=32841) by bay.acenet.us with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89_1) (envelope-from ) id 1f243Q-002DaQ-Ny; Fri, 30 Mar 2018 20:07:33 -0400 Subject: Re: [HACKERS] AdvanceXLInsertBuffer vs. WAL segment compressibility To: Michael Paquier , Tom Lane References: <20180326032731.GM24540@tamriel.snowman.net> <20180326054354.GB2759@paquier.xyz> <5ABAC668.5080203@anastigmatix.net> <8c00b26a-d6da-5764-e67e-9c4d8128081a@2ndquadrant.com> <5ABD9083.5050908@anastigmatix.net> <12915.1522433926@sss.pgh.pa.us> <20180330182423.GS24540@tamriel.snowman.net> <24353.1522441284@sss.pgh.pa.us> <5ABEC2C0.5040207@anastigmatix.net> <11426.1522451462@sss.pgh.pa.us> <20180330235757.GA1394@paquier.xyz> Cc: Stephen Frost , Tomas Vondra , Daniel Gustafsson , Michael Paquier , Heikki Linnakangas , Robert Haas , Bruce Momjian , PostgreSQL Hackers From: Chapman Flack Message-ID: <5ABED143.80605@anastigmatix.net> Date: Fri, 30 Mar 2018 20:07:31 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: <20180330235757.GA1394@paquier.xyz> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-OutGoing-Spam-Status: No, score=-100.2 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap+anastigmatix.net/only user confirmed/virtual account not confirmed X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 03/30/18 19:57, Michael Paquier wrote: > look for tools using XLP_BKP_REMOVABLE. One is pglesslog that we > already know about. However I have to be honest, I have not been able > to find its source code, I'm glad it wasn't just me. -Chap