Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZIWSo-0000Ca-Fu for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Jul 2015 06:28:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZIWSo-0005uu-1b for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Jul 2015 06:28:10 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZIWSn-0005u2-CT for pgsql-hackers@postgresql.org; Fri, 24 Jul 2015 06:28:09 +0000 Received: from mail-wi0-x235.google.com ([2a00:1450:400c:c05::235]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZIWSk-0006LC-7Y for pgsql-hackers@postgresql.org; Fri, 24 Jul 2015 06:28:08 +0000 Received: by wibxm9 with SMTP id xm9so14108598wib.0 for ; Thu, 23 Jul 2015 23:27:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=sender:message-id:date:from:reply-to:user-agent:mime-version:to:cc :subject:references:in-reply-to:content-type :content-transfer-encoding; bh=yJg6FdjEsQ4Hc+KT4V94d1NHYB7Rh1sYQtgEVEAbtlM=; b=e1LcU7AkrQT2EIlipbJRBD3/JRUdIIzQ15FkSQS5cwRxPT0q9fVdrcZ2AYLR0Wgj0P EcqKeNNIUKS4iXd+R7W6egEbneQ+VDmYIafosW2yL4KIBQ6qd32LDaVMQrep2Wpx+nFh /F3moDn1xxrXbJvglJ69TlT/KXFjK3qDB1V2njAPOEPbKWN56+UP6Dj4AfytqhgKu9ch cpboVKHOsci05Iai9YYyWTi/XmjEMDfV6meRSJ3h4mrHevjoqAOiKKA0kK0VX/7A27vd lYxBgB9gZ5Xrlo2Gc79rAJrCchCJ4wjH4F6wqfRABjhW3Mi/Xou2IRW+mV1rWK7RWrQQ V1qw== X-Received: by 10.180.37.200 with SMTP id a8mr3969293wik.26.1437719236438; Thu, 23 Jul 2015 23:27:16 -0700 (PDT) Received: from [192.168.1.105] (dsl-hkibrasgw1-58c38f-82.dhcp.inet.fi. [88.195.143.82]) by smtp.gmail.com with ESMTPSA id be9sm10891606wjb.26.2015.07.23.23.27.14 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 23 Jul 2015 23:27:15 -0700 (PDT) Message-ID: <55B1DAC1.3030804@iki.fi> Date: Fri, 24 Jul 2015 09:27:13 +0300 From: Heikki Linnakangas Reply-To: hlinnaka@iki.fi User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.7.0 MIME-Version: 1.0 To: Robert Haas CC: Simon Riggs , Tom Lane , Andres Freund , Fujii Masao , Martijn van Oosterhout , PostgreSQL-development Subject: Re: WAL logging problem in 9.4.3? References: <28320.1435935120@sss.pgh.pa.us> <20150703164931.GI3291@awork2.anarazel.de> <20150703170229.GJ3291@awork2.anarazel.de> <20150703172605.GM3291@awork2.anarazel.de> <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> <55AFC302.1060805@iki.fi> In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.4 (--) 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/23/2015 09:38 PM, Robert Haas wrote: > On Wed, Jul 22, 2015 at 12:21 PM, Heikki Linnakangas wrote: >> >> This is more invasive than I'd like to backpatch, but I think it's the >> simplest approach that works, and doesn't disable any of the important >> optimizations we have. > > Hmm, isn't HeapNeedsWAL() a lot more costly than RelationNeedsWAL()? Yes. But it's still very cheap, especially in the common case that the pending syncs hash table is empty. > Should we be worried about that? It doesn't worry me. - Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers