Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dcsLs-0001Hp-Du for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Aug 2017 12:02:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dcsLs-0006Ia-0b for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Aug 2017 12:02:12 +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_2) (envelope-from ) id 1dcsKJ-0002LN-FM for pgsql-hackers@postgresql.org; Wed, 02 Aug 2017 12:00:35 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dcsKF-0001xs-M4 for pgsql-hackers@postgresql.org; Wed, 02 Aug 2017 12:00:34 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id F2C8B21C0911; Wed, 2 Aug 2017 15:00:27 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Subject: Re: Proposal for CSN based snapshots DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1501675227; bh=UTZPNL7LN1I+THZ/7lgLuL+XK1FhpE2bqXU5nadIlnY=; h=To:References:Cc:From:Date:In-Reply-To; b=c1iNxQMB0165z8RJRjyU1nHL9cIuZ0sz5qIgcLBEysU/r1E39c7kZBBA0yrBizsyM 7nTX+vRRF4EpuVrbatG5DfKSZnTnbW1TpFtlL512AHOfO8NZd6Dc3pFkwh/KXDzjtT 36Yhv87DzOlrw9P3s8RIiKDlhW1G3eCgGNk1G8aw= To: Amit Kapila References: <53FD7DCC.5020005@vmware.com> <69041c5a-ec60-3c54-49d0-5df071b27f52@iki.fi> <389b45d1-f4f8-a333-03ef-efb94c8d6087@iki.fi> <20160822173852.ivt5to662zoc5rfs@alap3.anarazel.de> <4495d803-6ff2-488b-f58d-bab990ee660e@iki.fi> <0c4fb3ae-a828-5f07-79e3-0728e31e31b1@iki.fi> <725708e3-49f9-f26c-89bc-e8d410dcba09@postgrespro.ru> <41bcb678-51ce-3529-402a-cbf3ee19dbd8@postgrespro.ru> Cc: Michael Paquier , Heikki Linnakangas , Andres Freund , Robert Haas , Alexander Korotkov , Simon Riggs , Dilip Kumar , Jeff Davis , PostgreSQL-development , Alvaro Herrera , Greg Stark , Andres Freund , Rajeev rastogi , Markus Wanner , Ants Aasma , Bruce Momjian , obartunov , Teodor Sigaev , Borodin Vladimir From: Alexander Kuzmenkov Message-ID: <2599a9b7-7de2-975f-2a9f-529fe9ad9b17@postgrespro.ru> Date: Wed, 2 Aug 2017 15:00:27 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit 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 > What problem exactly you are seeing in the clog, is it the contention > around CLOGControlLock or generally accessing CLOG is slower. If > former, then we already have a patch [1] to address it. It's the contention around CLogControlLock. Thank you for the pointer, next time I'll try it with the group clog update patch. -- Alexander Kuzmenkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers