From owner-freebsd-performance@freebsd.org Fri Jun 3 18:29:06 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 8E6AFB69006 for ; Fri, 3 Jun 2016 18:29:06 +0000 (UTC) (envelope-from adrian.chadd@gmail.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 6B9961941 for ; Fri, 3 Jun 2016 18:29:06 +0000 (UTC) (envelope-from adrian.chadd@gmail.com) Received: by mailman.ysv.freebsd.org (Postfix) id 673F8B69002; Fri, 3 Jun 2016 18:29:06 +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 668E0B69001; Fri, 3 Jun 2016 18:29:06 +0000 (UTC) (envelope-from adrian.chadd@gmail.com) Received: from mail-io0-x229.google.com (mail-io0-x229.google.com [IPv6:2607:f8b0:4001:c06::229]) (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 2A02C193F; Fri, 3 Jun 2016 18:29:06 +0000 (UTC) (envelope-from adrian.chadd@gmail.com) Received: by mail-io0-x229.google.com with SMTP id k19so69317676ioi.3; Fri, 03 Jun 2016 11:29:06 -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:from:date:message-id :subject:to:cc; bh=KKzenDbUPi7frWUiQAS7wiF9ApSqtIvscKaM1T0WR4o=; b=P46QW1thYnfpKsI/nzfsePIFB+NbaHpcwS74Kg5S1lxGc9L87ka+hKjYXE8bz/Ynb6 FDfjyJp+5BGgblh7zAH8GXREKPUVirfqe0K0soAa01YcmbNVtzKAVvI3gc/GRm8OmGgA VueE8Kss9rI8/qR5q5gv5TOzxovMmZZ6jkfbn+0/HeDIEvoOk9NNEiY0+hCVsoqoR6By isTMlj8hLklaYasfUqhZnyMY3OPQFt4VP+F3LBuySa1rzCXRdzWXEYofs1br4Dem9952 MOMWfWDukHEXTFliy+pRSgpvK5wKK3nY2R12of0pCyUQHVIwYZOpxWMBmRS2gUD37nej zgYQ== 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=KKzenDbUPi7frWUiQAS7wiF9ApSqtIvscKaM1T0WR4o=; b=INu6MMsgXjdkN1KQ9zuMxGGYwib6SSr8Vtg6z5pInCtgpuYbs3ETEKtAmimD81v0II 37PO+zEYgy913y32Rx/q+Lom0wI6eqcr2dGV6vulS/9mfgrJmO4W8vp+J7K06xfyM+FH kCB4Yc3k7vPi0pQIhKrQhjQ/R8eaFGcawG72NCqlHNvcVCjDsutdJJBlv15+XDYx5Pt5 5PyPzIdQsYfyIrJWdMUyRMJPa63xXSLDIcj5X+AfG+SxCB5n6Lj8Tz/v47avkyd1e2sR bzCqVQ+NcQNswv+cEV9m/obzwwPXUqzSMu6ZNHO9fbMdg9mY4giyj7VDH8M2PfvgjM5A m6eQ== X-Gm-Message-State: ALyK8tJ8Hj04ZRM8SI5P3y2xMtN58mef/5LHTc6lbhCo3a2hD+eIlWJG3oceQVISA0HWVBWXGQtcbOqoz9Kirg== X-Received: by 10.36.92.199 with SMTP id q190mr1399491itb.25.1464978544648; Fri, 03 Jun 2016 11:29:04 -0700 (PDT) MIME-Version: 1.0 Sender: adrian.chadd@gmail.com Received: by 10.36.113.3 with HTTP; Fri, 3 Jun 2016 11:29:03 -0700 (PDT) In-Reply-To: References: <20140627125613.GT93733@kib.kiev.ua> <201408121409.40653.jhb@freebsd.org> <201408141147.45698.jhb@freebsd.org> <53ECFDC8.1070200@rice.edu> <20160603172633.GY38613@kib.kiev.ua> <20160603175546.GZ38613@kib.kiev.ua> From: Adrian Chadd Date: Fri, 3 Jun 2016 11:29:03 -0700 X-Google-Sender-Auth: e_d2MJ3KDnc3yC014PpWP85tZWA Message-ID: Subject: Re: PostgreSQL performance on FreeBSD To: Konstantin Belousov Cc: Alan Somers , Alan Cox , John Baldwin , Alan Cox , freebsd-current , performance@freebsd.org, "current@freebsd.org" Content-Type: text/plain; charset=UTF-8 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: Fri, 03 Jun 2016 18:29:06 -0000 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? -adrian