Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M283786=pgsql-hackers-arkari@postgresql.org>)
 id 1ZowN6-0002mE-SI
 for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Oct 2015 16:36:16 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-hackers-owner+M283786=pgsql-hackers-arkari@postgresql.org>)
 id 1ZowN6-0000RX-Es
 for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Oct 2015 16:36:16 +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) (envelope-from <alvherre@alvh.no-ip.org>)
 id 1ZowN5-0000QH-MD
 for pgsql-hackers@postgresql.org; Wed, 21 Oct 2015 16:36:15 +0000
Received: from out.smtp-auth.no-ip.com ([8.23.224.60])
 by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <alvherre@alvh.no-ip.org>)
 id 1ZowMy-0000LG-Qg
 for pgsql-hackers@postgresql.org; Wed, 21 Oct 2015 16:36:15 +0000
X-No-IP: alvh.no-ip.org@noip-smtp
X-Report-Spam-To: abuse@no-ip.com
Received: from alvin.alvh.no-ip.org (unknown [200.104.52.149])
 (Authenticated sender: alvh.no-ip.org@noip-smtp)
 by smtp-auth.no-ip.com (Postfix) with ESMTPA id A706D40139A;
 Wed, 21 Oct 2015 09:36:02 -0700 (PDT)
Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000)
 id C2DA4E9F; Wed, 21 Oct 2015 11:53:44 -0300 (CLT)
Date: Wed, 21 Oct 2015 11:53:44 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Simon Riggs <simon@2ndQuadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>,
 Andres Freund <andres@anarazel.de>, Fujii Masao <masao.fujii@gmail.com>,
 Martijn van Oosterhout <kleptog@svana.org>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: WAL logging problem in 9.4.3?
Message-ID: <20151021145344.GW3391@alvherre.pgsql>
References: <20150703170229.GJ3291@awork2.anarazel.de>
 <20150703172605.GM3291@awork2.anarazel.de>
 <CAHGQGwGGM2OBh4WOTd8wWqxKzRy+WdJX+-fxxPCWNz4eeJ1aQQ@mail.gmail.com>
 <27532.1436195680@sss.pgh.pa.us>
 <20150706152123.GK8902@alap3.anarazel.de>
 <28415.1436197794@sss.pgh.pa.us>
 <20150709182315.GG10242@alap3.anarazel.de>
 <29916.1436483171@sss.pgh.pa.us>
 <CANP8+jKN4V4MJEzFN_iEtdZ+1oM=YETxvmuu1YK4UMXQY2gaGw@mail.gmail.com>
 <55AFC302.1060805@iki.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <55AFC302.1060805@iki.fi>
User-Agent: Mutt/1.5.23 (2014-03-12)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Heikki Linnakangas wrote:

> Thanks. For comparison, I wrote a patch to implement what I had in mind.
> 
> When a WAL-skipping COPY begins, we add an entry for that relation in a
> "pending-fsyncs" hash table. Whenever we perform any action on a heap that
> would normally be WAL-logged, we check if the relation is in the hash table,
> and skip WAL-logging if so.

I think this wasn't applied, was it?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers