From owner-freebsd-performance@freebsd.org Tue Jun 21 19:48:01 2016 Return-Path: Delivered-To: freebsd-performance@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 D98DFAC532F for ; Tue, 21 Jun 2016 19:48:01 +0000 (UTC) (envelope-from sobomax@sippysoft.com) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id B45D32001 for ; Tue, 21 Jun 2016 19:48:01 +0000 (UTC) (envelope-from sobomax@sippysoft.com) Received: by mailman.ysv.freebsd.org (Postfix) id B02CAAC532B; Tue, 21 Jun 2016 19:48:01 +0000 (UTC) Delivered-To: performance@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 AFD58AC532A for ; Tue, 21 Jun 2016 19:48:01 +0000 (UTC) (envelope-from sobomax@sippysoft.com) Received: from mail-oi0-x234.google.com (mail-oi0-x234.google.com [IPv6:2607:f8b0:4003:c06::234]) (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 617911FDC for ; Tue, 21 Jun 2016 19:48:01 +0000 (UTC) (envelope-from sobomax@sippysoft.com) Received: by mail-oi0-x234.google.com with SMTP id r2so940742oih.2 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=btuXcFJTVuuJjaSplhdJ59uqd895bLANJHeCbg6jsJnhOtyAUvxBngeDHbLCa2TGw1 Wx/rnLRVEJQTodPsl0FNt/VAPpSoMxw1KWkKNrRGMlQaX9rYTIh91Ak2/tvMmLkYDPZi VUqRPKEOc8+96Ys9w6Pf2fwWr2+xC0yl/ULToKP/sMQWBYfi8lqSG/zYkY4DFHuZdFjt wlk7i4K5YF56Gs2/YmKPN1LPKHZqPcDTXCz/6X1W3Oa6A31ymprcIjiiUAnAZZQDW46v sgWtUV/mKVBmAGwl+I5sc34HgbycOtGiObi/16Rp5A/zLb6bOlEPgY655wZJB82xA7++ t7dQ== X-Gm-Message-State: ALyK8tKoSPyzfHcotc4nUu2ypfe9ZpJNCzBcfMfmJxgyOtcceJUE/hzqTLyDEKcZ/fQKuQrUgNZka6D/PvmMbFFQ 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" X-Mailman-Approved-At: Tue, 21 Jun 2016 20:20:31 +0000 Content-Type: text/plain; charset=UTF-8 X-Content-Filtered-By: Mailman/MimeDel 2.1.22 X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.22 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 21 Jun 2016 19:48:02 -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" > >