From owner-freebsd-current@FreeBSD.ORG Thu Jul 17 15:45:33 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 C11458F9; Thu, 17 Jul 2014 15:45:33 +0000 (UTC) Received: from mail-we0-x22d.google.com (mail-we0-x22d.google.com [IPv6:2a00:1450:400c:c03::22d]) (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 36FB723CC; Thu, 17 Jul 2014 15:45:33 +0000 (UTC) Received: by mail-we0-f173.google.com with SMTP id q58so3399358wes.4 for ; Thu, 17 Jul 2014 08:45:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=6LmG3rTHaBSoMk93ffyAaidW7Jc/LoXXVmRh4VUX9u4=; b=a28PCZYaPow4kicRV0dJ6ffKWnP+dqE1/OnwQ1mhw8dGPz+RHhK3N6lzYCHnaHaSq4 Jl5+igPlT4lPnoLTYazccGq3vQN2Q01c0+3pyJstvnLSvddZarVzfpjUC1mUPe25ptYW T54MQaAe2s+tRCcxAf6ax0qodnXfERgP7Aty3gUa6BzQGF9cYITwZXV6NVHcr9HH5gqS KOJdmhFUoPJ3jeSz6JA9aSvV3Pia8RnIr2fMDesG2HgAvjLah5LYhjRDxYRx++HRtnld DzjB+K0BPuXvLdkrGeIGDsBKlUxXsaozhaYgK0qOOYpj29/qBbjWC8/CP+szAniXTyxW FIxg== X-Received: by 10.180.24.97 with SMTP id t1mr23564487wif.45.1405611929767; Thu, 17 Jul 2014 08:45:29 -0700 (PDT) Received: from [192.168.2.30] ([2.176.167.69]) by mx.google.com with ESMTPSA id eh10sm22332778wic.0.2014.07.17.08.45.27 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Thu, 17 Jul 2014 08:45:28 -0700 (PDT) Message-ID: <53C7EFA3.3070100@gmail.com> Date: Thu, 17 Jul 2014 20:15:39 +0430 From: Hooman Fazaeli User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130215 Thunderbird/17.0.3 MIME-Version: 1.0 To: Konstantin Belousov Subject: Re: PostgreSQL performance on FreeBSD References: <20140627125613.GT93733@kib.kiev.ua> <20140716132938.GB93733@kib.kiev.ua> In-Reply-To: <20140716132938.GB93733@kib.kiev.ua> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Mailman-Approved-At: Thu, 17 Jul 2014 16:11:11 +0000 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: Thu, 17 Jul 2014 15:45:33 -0000 On 7/16/2014 5:59 PM, 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'. Thanks for the great work! Did you tested the effect of hyper-threading (on or off) on the results? -- Best regards. Hooman Fazaeli