From owner-freebsd-current@FreeBSD.ORG Wed Jul 16 17:52:47 2014 Return-Path: Delivered-To: current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 3A77DABA; Wed, 16 Jul 2014 17:52:47 +0000 (UTC) Received: from mail-qc0-x236.google.com (mail-qc0-x236.google.com [IPv6:2607:f8b0:400d:c01::236]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id DC75B217C; Wed, 16 Jul 2014 17:52:46 +0000 (UTC) Received: by mail-qc0-f182.google.com with SMTP id r5so1101075qcx.13 for ; Wed, 16 Jul 2014 10:52:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:date:message-id:subject :from:to:cc:content-type; bh=tbZl6MpAurodEO9oy5ctH4e7jfjLNzJO/2pF+5Hv2as=; b=VGBR2FJvgeUUcqO6TUWYU55fiGbZXaPooeQbuwv4zl7BHWZPVD65RtedTuCSGvb6wQ mX1s2f+vTc3du+tDFi/0F9hlJWbaRPOE8+8sdLZiI/WrGXwPt1tH6myh1I9+LcK1iejG QSn5YnTFXgFa1eO0Dy7nx1w9jSxj6Y6ffD8Txqgsd6Mwr6aCkSgaeBs9McuFG0X91A1/ P8xdaglBnLvu2HXqLMcEebSvywGg3iR1BFkXLrEtejSpf6PT2RXMB31HpePIbQNBbzIN blruwVmIsjeTZr6jMlfI0RrR/80SiDepFUXWLRVUALNVcNdKsJO6FSbJOIKKAS9AWGtb yCjQ== MIME-Version: 1.0 X-Received: by 10.140.22.134 with SMTP id 6mr45383977qgn.4.1405533166037; Wed, 16 Jul 2014 10:52:46 -0700 (PDT) Sender: adrian.chadd@gmail.com Received: by 10.224.202.193 with HTTP; Wed, 16 Jul 2014 10:52:45 -0700 (PDT) In-Reply-To: <20140716132938.GB93733@kib.kiev.ua> References: <20140627125613.GT93733@kib.kiev.ua> <20140716132938.GB93733@kib.kiev.ua> Date: Wed, 16 Jul 2014 10:52:45 -0700 X-Google-Sender-Auth: lJXcZq-CeDhZh07j61Osw64Q0d0 Message-ID: Subject: Re: PostgreSQL performance on FreeBSD From: Adrian Chadd To: Konstantin Belousov Content-Type: text/plain; charset=UTF-8 Cc: performance@freebsd.org, "current@freebsd.org" X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 16 Jul 2014 17:52:47 -0000 Hi! On 16 July 2014 06:29, Konstantin Belousov wrote: > On Fri, Jun 27, 2014 at 03:56:13PM +0300, Konstantin Belousov wrote: >> Hi, >> I did some measurements and hacks to see about the performance and >> scalability of PostgreSQL 9.3 on FreeBSD, sponsored by The FreeBSD >> Foundation. >> >> The results are described in https://kib.kiev.ua/kib/pgsql_perf.pdf. >> The uncommitted patches, referenced in the article, are available as >> https://kib.kiev.ua/kib/pig1.patch.txt >> https://kib.kiev.ua/kib/patch-2 > > A followup to the original paper. > > Most importantly, I identified the cause for the drop on the graph > after the 30 clients, which appeared to be the debugging version > of malloc(3) in libc. > > Also there are some updates on the patches. > > New version of the paper is available at > https://www.kib.kiev.ua/kib/pgsql_perf_v2.0.pdf > The changes are marked as 'update for version 2.0'. Would you mind trying a default (non-PRODUCTION) build, but with junk filling turned off? adrian@adrian-hackbox:~ % ls -l /etc/malloc.conf lrwxr-xr-x 1 root wheel 10 Jun 24 04:37 /etc/malloc.conf -> junk:false That fixes almost all of the malloc debug performance issues that I see without having to recompile. I'd like to know if you see any after that. Thanks! -a