Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X7ZC7-0004sA-9t for pgsql-performance@arkaria.postgresql.org; Thu, 17 Jul 2014 00:05:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X7ZC6-00008m-Jw for pgsql-performance@arkaria.postgresql.org; Thu, 17 Jul 2014 00:05:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X7ZC4-0008Tt-EJ for pgsql-performance@postgresql.org; Thu, 17 Jul 2014 00:05:04 +0000 Received: from [2404:130:0:10::40:2] (helo=mail.catalyst.net.nz) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X7ZBy-00014W-16 for pgsql-performance@postgresql.org; Thu, 17 Jul 2014 00:05:02 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.catalyst.net.nz (Postfix) with ESMTP id 304B332582; Thu, 17 Jul 2014 12:04:55 +1200 (NZST) X-Virus-Scanned: Debian amavisd-new at catalyst.net.nz Received: from mail.catalyst.net.nz ([127.0.0.1]) by localhost (bertrand.catalyst.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 4Ngj9UJrhFVl; Thu, 17 Jul 2014 12:04:53 +1200 (NZST) Received: from [IPv6:2404:130:0:1000:e52f:55a:209e:3fce] (unknown [IPv6:2404:130:0:1000:e52f:55a:209e:3fce]) (Authenticated sender: mark.kirkwood) by mail.catalyst.net.nz (Postfix) with ESMTPSA id 3896E320A0; Thu, 17 Jul 2014 12:04:53 +1200 (NZST) Message-ID: <53C71429.3000107@catalyst.net.nz> Date: Thu, 17 Jul 2014 12:09:13 +1200 From: Mark Kirkwood User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: Kevin Grittner , Andres Freund CC: "pgsql-performance@postgresql.org" Subject: Re: 60 core performance with 9.3 References: <53ACB190.2030206@catalyst.net.nz> <53ACD6C4.9050605@catalyst.net.nz> <20140627091951.GA16680@awork2.anarazel.de> <53B283F3.7020005@catalyst.net.nz> <20140701101307.GO21422@awork2.anarazel.de> <53BF326F.2070903@catalyst.net.nz> <20140711082207.GI17261@awork2.anarazel.de> <53BFA63C.60909@catalyst.net.nz> <1405084749.26978.YahooMailNeo@web122306.mail.ne1.yahoo.com> In-Reply-To: <1405084749.26978.YahooMailNeo@web122306.mail.ne1.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2404:130:0:10::40:2 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 12/07/14 01:19, Kevin Grittner wrote: > > It might be worth a test using a cpuset to interleave OS cache and > the NUMA patch I submitted to the current CF to see whether this is > getting into territory where the patch makes a bigger difference. > I would expect it to do much better than using numactl --interleave > because work_mem and other process-local memory would be allocated > in "near" memory for each process. > > http://www.postgresql.org/message-id/1402267501.41111.YahooMailNeo@web122304.mail.ne1.yahoo.com > Thanks Kevin - I did try this out - seemed slightly better than using --interleave, but almost identical to the results posted previously. However looking at my postgres binary with ldd, I'm not seeing any link to libnuma (despite it demanding the library whilst building), so I wonder if my package build has somehow vanilla-ified the result :-( Also I am guessing that with 60 cores I do: $ sudo /bin/bash -c "echo 0-59 >/dev/cpuset/postgres/cpus" i.e cpus are cores not packages...? If I've stuffed it up I'll redo! Cheers Mark -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance