Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bRt7G-000436-Im for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Jul 2016 03:33:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bRt7F-000360-M9 for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Jul 2016 03:33:09 +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 1bRt7D-00034U-LA for pgsql-hackers@postgresql.org; Tue, 26 Jul 2016 03:33:07 +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.84_2) (envelope-from ) id 1bRt7A-00051g-BR for pgsql-hackers@postgresql.org; Tue, 26 Jul 2016 03:33:07 +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=MZIUyUjPzNj6WDhLa874cuwg31isAc70ihEANnsE/1g=; b=qHm2RJihsiX5zlORD8pf2EleJh /2tz7D5ckq1GaoB3HTQuEDuZ59t6tsFegGERM3+LWjDWUiSwmt6dxWoYTReWhmM/de4SXpzrFKGcC kR4PLlCOl69XrGQhiALvVQoYbvJTLIEmajWLvYZWQwDIZ4DarKksWg89O6S4p/kOLp9hw2MVjWcUg wJAR9RvsmYeeDSGu2Qz92wjfZbC4IliEkhzDVFBy/19+6iayjsOSfUk7ZcW5Om+8yFP75mkorAd0X aZDAURIkecU/C+T3jSAh9K2jK1/jsHqqXlTOoSAhp8TW5sPKx1AuYZ/jK0THpAxOftNRP3/43x/3d +kb+YiJw==; Received: from [184.19.62.150] (port=50923) by bay.acenet.us with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.87) (envelope-from ) id 1bRt76-002oPl-Fm; Mon, 25 Jul 2016 23:33:00 -0400 Subject: Re: AdvanceXLInsertBuffer vs. WAL segment compressibility To: Michael Paquier References: <579297F8.7020107@anastigmatix.net> <57962061.9010506@anastigmatix.net> Cc: Amit Kapila , PostgreSQL Hackers From: Chapman Flack Message-ID: <5796D9EB.6070407@anastigmatix.net> Date: Mon, 25 Jul 2016 23:32:59 -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: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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: X-Pg-Spam-Score: -1.8 (-) 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 On 07/25/16 22:09, Michael Paquier wrote: > This is over-complicating things for little gain. The new behavior of > filling in with zeros the tail of a segment makes things far better > when using gzip in archive_command. Then how about filling with actual zeros, instead of with mostly-zeros as is currently done? That would work just as well for gzip, and would not sacrifice the ability to do 100x better than gzip. -Chap -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers