From owner-freebsd-current@freebsd.org Tue Jun 21 19:48:01 2016 Return-Path: Delivered-To: freebsd-current@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 97BE7AC5325 for ; Tue, 21 Jun 2016 19:48:01 +0000 (UTC) (envelope-from sobomax@sippysoft.com) Received: from mail-oi0-x233.google.com (mail-oi0-x233.google.com [IPv6:2607:f8b0:4003:c06::233]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 57C261FD6 for ; Tue, 21 Jun 2016 19:48:01 +0000 (UTC) (envelope-from sobomax@sippysoft.com) Received: by mail-oi0-x233.google.com with SMTP id s66so946625oif.1 for ; Tue, 21 Jun 2016 12:48:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sippysoft-com.20150623.gappssmtp.com; s=20150623; h=mime-version:sender:in-reply-to:references:from:date:message-id :subject:to:cc; bh=BWu424J08XNTOZZDYk8pJct/4YcWXKZL5/IlcVjBLww=; b=iJPKziUxHO0tsRC/zzIVAVu38nJ8yRoDGgld62ptXQbu6JV7h5Are7VbL5UctnPF5v oKdHL616cNCASpZU10m7vElATRjPg601xJ2qxxDuYk5aB1qvpDw/NY/Dg/J7Xxez/CO8 Vh9cO/9Q6wEJH1jCiJh3yQHVx5mlBvHCrg/R9ThvqwFVRZSdHCO0ehTAjFNeAFphPQRy FsFGQpjP8FZVU6IPT3Hdg71Kmke9nQom4A0NrovudgYvTbA0NzT3Y++/xcGvq3eMpOAU DXY1mtV+JO8PLBigpRccrC8I9Xt4s9BKN0x+/ZdBjgc1FEOaYfEBuM3DJDxvt+SAxHtm DnTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:sender:in-reply-to:references:from :date:message-id:subject:to:cc; bh=BWu424J08XNTOZZDYk8pJct/4YcWXKZL5/IlcVjBLww=; b=dQom8qQZkc4A3uCjIj1sirQbk0nthwuro4cw05KAzH/a5hp1tDhiY6Gai2ImsSVXBF NMuRycWru1TJwlcsUu+f0+s66mreL/K0m9E36QgKxngbTItP43mJqp8y3VC2uTcj+zr1 uSCp2LEPMiMCEra8OmozrKk7H9/n0zVnXDu1IcTke21adXDen9O20U9YVI/q2OVJqTts B61GbCunTftwJGyyEL0Vj+lpj2lZlFcH33S0JQVaq7nFdtxwmAvrFcl7Bvsa7h6Ldwyl eVBbVIhi1SVhnG4ibIybLyJQPo6ZOHCPmAdVJr8ssoJ53TH6tL0BGe1yyzpOo/D661+K mUWQ== X-Gm-Message-State: ALyK8tLYkXa11Xef0ZstGpmW/SX35ldPKaa3uhYOC+lFk0I1R3+0uwzY9xKyOzDI0Po3RkgKY4t69kgukBRUfY7j X-Received: by 10.202.240.11 with SMTP id o11mr67831oih.45.1466538480657; Tue, 21 Jun 2016 12:48:00 -0700 (PDT) MIME-Version: 1.0 Sender: sobomax@sippysoft.com Received: by 10.157.41.209 with HTTP; Tue, 21 Jun 2016 12:48:00 -0700 (PDT) In-Reply-To: <1603235.2ShtoCfSqO@ralph.baldwin.cx> References: <20140627125613.GT93733@kib.kiev.ua> <1603235.2ShtoCfSqO@ralph.baldwin.cx> From: Maxim Sobolev Date: Tue, 21 Jun 2016 12:48:00 -0700 X-Google-Sender-Auth: TGqbUJWsBeRDE3jS2pTvxu0J558 Message-ID: Subject: Re: PostgreSQL performance on FreeBSD To: John Baldwin Cc: Adrian Chadd , Konstantin Belousov , Alan Somers , Alan Cox , Alan Cox , freebsd-current , performance@freebsd.org, "current@freebsd.org" Content-Type: text/plain; charset=UTF-8 X-Content-Filtered-By: Mailman/MimeDel 2.1.22 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.22 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: Tue, 21 Jun 2016 19:48:01 -0000 Thanks, Konstantin for the great work, we are definitely looking forward to get all those improvements to be part of the default FreeBSD kernel/port. Would be nice if you can post an update some day later as to what's integrated and what's not. Just in case, I've opened #14206 with PG to switch us to using POSIX semaphores by default. Apart from the mentioned performance benefits, SYSV semaphores are PITA to deal with as they come in very limited quantities by default. Also they might stay around if PG dies/gets nuked and prevent it from starting again due to overflow. We've got some quite ugly code to clean up those using ipcrm(1) in our build scripts to deal with just that. I am happy that code could be retired now. -Maxim On Fri, Jun 3, 2016 at 11:53 AM, John Baldwin wrote: > On Friday, June 03, 2016 11:29:03 AM Adrian Chadd wrote: > > On 3 June 2016 at 11:27, Adrian Chadd wrote: > > > > > That and the other NUMA stuff is something to address in -12. > > > > And, I completely welcome continued development in NUMA scaling in > > combination with discussion. The iterator changes I committed are a > > more generic version of a patch people were applying on top of -10 and > > -head for at least what, three years now? Maybe more if -9 also just > > did round-robin and not first-touch? > > 8 and 9 did first-touch. Only 10 did round-robin. > > -- > John Baldwin > _______________________________________________ > freebsd-current@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org" > >