Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bgfHp-0000SO-Mf for pgsql-hackers@arkaria.postgresql.org; Sun, 04 Sep 2016 21:49:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bgfHo-0000J7-8x for pgsql-hackers@arkaria.postgresql.org; Sun, 04 Sep 2016 21:49:08 +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 1bgfHn-0000IP-1M for pgsql-hackers@postgresql.org; Sun, 04 Sep 2016 21:49:07 +0000 Received: from mail-wm0-x235.google.com ([2a00:1450:400c:c09::235]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bgfHj-0002XE-VA for pgsql-hackers@postgresql.org; Sun, 04 Sep 2016 21:49:05 +0000 Received: by mail-wm0-x235.google.com with SMTP id w12so11224311wmf.0 for ; Sun, 04 Sep 2016 14:49:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding; bh=S0EgVu+0bMRFr6cxvZJtzkCboKQVuIn7Lsuqkrgcsgs=; b=AAVWJSvF51dixM7mXViqXn8zOXjuXqy82kvuCchNYvTsrNF1iR4lHV5XRYwpH6mY4M r2qRCZoy5PjwmCcFt66EhXcgmy8G8ivIBWEd3arF2B2tPqLrJqSIdQA4gafh/wSavTGa 16u25cqUeq16H955n/Vz1Lwvct/W6GNwBpiK6JD/D7Pw8xcvEOh/ACzQ05limslF2usD vii7/DnQGYn9s7UQh0oHknkHnNRgAnm1jHAJxImZ/RdetRPSCaSFy4ZGe/KxLHOcRPc9 Y4zkxEA4gL6fgHPIn5pSMP6+kKkhYDFwH1x5E/QNrHqdT8hYUBlqAAqtekKOWLGWc5ml nLNQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=S0EgVu+0bMRFr6cxvZJtzkCboKQVuIn7Lsuqkrgcsgs=; b=T2BK0/tYY9PLGj6n7mwPdtWZ2WrFGA2nptfSGVfCS/RXNkMGqcqzSCT9eXQYWRf6K5 mg/OsYAJuKYwoEz7cEmAJFOrgDmuj64INnZ1NAmu+sYBRO0My2heLTTYg478nZVMO7jH kqa7KDHkmPYlNClzHcksdMyYNKcKOY8FN7DMSmWEaotUVkPbNg5PkNtupUXL9WRvVXUd qtgF0DFx7SgiBoL3Xm3xceIiQJecWwiT0rT03jkXbFNfnNtkcUoVyNz5HkhH/GE6txOw QVpNrtvmv6Dgw/2jAZaCGWIVcrLK9O2yTQ2W9z/kz/8PFlsNJM5PLaiZMVhbEj8NkmOJ ZTmg== X-Gm-Message-State: AE9vXwPjfydVO138ieQSBAL2MNldGWT4by+wzB1HqwI1Oe9clQpFDx8i0KEnf1V7J1rEGmaxkYAT2XJTEXbcwUsa+3K4Ckn++4BU3F2an7oVtuvnT9XPTGZFbah/7kv5QIZTQfYFYuBaXSAn8D5HSjjRDjE8yo8wllqUhU+cDquMcGTzEtW8Yf5xn/BvBpX6TbxuEej7u/n7 X-Received: by 10.194.157.194 with SMTP id wo2mr22083599wjb.120.1473025742518; Sun, 04 Sep 2016 14:49:02 -0700 (PDT) Received: from [10.137.2.20] ([5.32.60.221]) by smtp.gmail.com with ESMTPSA id n131sm16684324wmd.3.2016.09.04.14.49.00 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 04 Sep 2016 14:49:01 -0700 (PDT) Subject: Re: Speed up Clog Access by increasing CLOG buffers To: Amit Kapila , Andres Freund References: <20150903114137.GE27649@awork2.anarazel.de> <20160330230914.GH13305@awork2.anarazel.de> <20160408153054.hgubabeycowlu3tc@alap3.anarazel.de> Cc: pgsql-hackers From: Tomas Vondra Message-ID: <8bab43dd-bc76-0c41-950e-8101269dbf4b@2ndquadrant.com> Date: Sun, 4 Sep 2016 23:48:55 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:46.0) Gecko/20100101 Thunderbird/46.0a2 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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 Hi, This thread started a year ago, different people contributed various patches, some of which already got committed. Can someone please post a summary of this thread, so that it's a bit more clear what needs review/testing, what are the main open questions and so on? I'm interested in doing some tests on the hardware I have available, but I'm not willing spending my time untangling the discussion. thanks -- Tomas Vondra 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