Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cwdXq-0005jx-12 for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Apr 2017 23:43:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cwdXp-0006TU-Ke for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Apr 2017 23:43:57 +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 1cwdWK-0003Po-Rc for pgsql-hackers@postgresql.org; Fri, 07 Apr 2017 23:42:24 +0000 Received: from mail-qk0-x234.google.com ([2607:f8b0:400d:c09::234]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cwdWH-00084o-Q7 for pgsql-hackers@postgresql.org; Fri, 07 Apr 2017 23:42:24 +0000 Received: by mail-qk0-x234.google.com with SMTP id p68so49823596qke.1 for ; Fri, 07 Apr 2017 16:42:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=fdkXxMGlENjAvviyBp1Lse0SJoyciEIae2Z9uy0/LdE=; b=e4LtrMR62+0y229pviuDkq5Ck/Mk9o6tWoXxmpwQttrOKCVOedXWC8frVzRX/d6Q10 y1iby7xiGZ53S+1J/5nkxJ0sDB9VrH1Fz2TBEUjUFbpj450vWuKaXU97yZtM5amG4Xoq mlIK+O6GuwxBFr1waXw2hkev05gIFz4uIiQElwL1uIlgnLuocHoIggTTe5MHJe976oPr Z0xTM61MQOrkSK7xwAe14l6ZK3jiioz9vF5T4HW5lP5WciJ52RXw4ppsFV6WWmCTS3Qq ASakemEWe50YUaUjKG7YoQut4fWbZ851QdwvoPpdh/uE8k9npqXImHHKtEu+/p+XZair CtKw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=fdkXxMGlENjAvviyBp1Lse0SJoyciEIae2Z9uy0/LdE=; b=KcUtumpqQz51c07GYaN3zkyLtZvRugJ/ATuzRhHW4JRnUuk49iNcrcJUwWpIGnm1/0 BUKGvRD5CP/Ov+qzWgrpD1N45B83jBfHuSgA6dOkbQvCZJzGypCCFDzjz/nBtjimjc6B bGiXMGJdKakUpBni45dhhIZGMNxWGtsKKvnQxXKDapswWLM/Oa1n3FtWWC5zc3Havilb kkxdp/1i9Ah/j1v6umYSSlO0i68EABkTrI36nEIfYx9xk14NzHUSJZbDwuI0GGyNxBCk rsjcyRZ8fuiemC1IkjAFupRW+mtva978Xf7UrgV7t4bI/LuyjMcr+FP9OA9aUzcrNt2E fGqA== X-Gm-Message-State: AN3rC/7ReUiFniUmTakG7nzSYJTkaYL33B3vfvekH5Qd4Fu3Gi6e4fD3rvh6G4dP7WN7wsaV X-Received: by 10.55.3.66 with SMTP id 63mr24810226qkd.194.1491608540176; Fri, 07 Apr 2017 16:42:20 -0700 (PDT) Received: from alvin.alvh.no-ip.org ([179.57.115.10]) by smtp.gmail.com with ESMTPSA id 18sm4045543qtz.41.2017.04.07.16.42.19 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 07 Apr 2017 16:42:19 -0700 (PDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 687EB382; Fri, 7 Apr 2017 20:42:17 -0300 (-03) Date: Fri, 7 Apr 2017 20:42:17 -0300 From: Alvaro Herrera To: Kyotaro HORIGUCHI Cc: michael.paquier@gmail.com, david@pgmasters.net, hlinnaka@iki.fi, simon@2ndquadrant.com, tgl@sss.pgh.pa.us, andres@anarazel.de, masao.fujii@gmail.com, kleptog@svana.org, pgsql-hackers@postgresql.org Subject: Re: WAL logging problem in 9.4.3? Message-ID: <20170407234217.i345adtkknjfw6ss@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20170407233321.lpruyvn6r4tuujmt@alvherre.pgsql> User-Agent: NeoMutt/20170206-195-7adf12 (1.7.2) X-Pg-Spam-Score: -2.6 (--) 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 Alvaro Herrera wrote: > I suppose the rationale is that this shouldn't happen because any > operation that does things this way must hold an exclusive lock on the > relation. But that doesn't guarantee that the relcache entry is > completely stable, does it? If we can get proof of that, then this > technique should be safe, I think. It occurs to me that in order to test this we could run the recovery tests (including Michael's new 006 file, which you didn't include in your patch) under -D CLOBBER_CACHE_ALWAYS. I think that'd be sufficient proof that it is solid. -- Álvaro Herrera https://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