Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bbB6X-0000xz-BK for pgsql-hackers@arkaria.postgresql.org; Sat, 20 Aug 2016 18:34:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bbB6W-0003bP-Bp for pgsql-hackers@arkaria.postgresql.org; Sat, 20 Aug 2016 18:34:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bbB58-00023M-Rl for pgsql-hackers@postgresql.org; Sat, 20 Aug 2016 18:33:22 +0000 Received: from mail-lf0-x22e.google.com ([2a00:1450:4010:c07::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bbB55-0002Tl-Hr for pgsql-hackers@postgresql.org; Sat, 20 Aug 2016 18:33:22 +0000 Received: by mail-lf0-x22e.google.com with SMTP id l89so52795972lfi.1 for ; Sat, 20 Aug 2016 11:33:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=references:mime-version:in-reply-to:content-transfer-encoding :message-id:cc:from:subject:date:to; bh=v0tTAuqqDatPEosLGGo0jnH5Hqt4D0kGTMoHlZZ2sAM=; b=vxNMrUxJjnnahHjdstGiADjYuwyb0mHr0PKEgVlLjGjc+1SnPJgTvS0xKRGaKHwnfQ bH3+0IFeTwpvv++fhTbXLmtu3Lp00I+w80VOcjo8+zY6Vp/X4K8XoEntIA42UN92sgSj 5MOh7WfL7ytnpG2qsNGvPEnQwgmI0WdQpzzWDbmSJ58e4uW5q9gJLEJB1w5/EW42b5J3 UkU6E4clPHku39stea5QvunbUYfbb9uQUHOPdgNYJTSdgQ/JpDS+30LljlhNAZMeCoP/ NdHRiKWpapoA5182XnrEu3ZEu+5ZVqpSoNDnzBVx35nvrjsyuMdkDMTKYoZZdHNamGuh +w6w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:references:mime-version:in-reply-to :content-transfer-encoding:message-id:cc:from:subject:date:to; bh=v0tTAuqqDatPEosLGGo0jnH5Hqt4D0kGTMoHlZZ2sAM=; b=dIkHlCV9h856kTTHA+Qc6aCqSk/6+WlSCHChqr1S4il+4zB3Dh7Ab6KdbrLf/J1ylv BKMVP9c49bGRrXIW4lQaKX4Xxw/eOpajC5FY57sK2EebWPzdqVR8KOi7XikWQ4EsitEt /dmwJiOCqnWoOCd3u2OsXLfmvnZjBOBMEukbeA+MmHy0Yvay2j2JeQAlXrmlimGSwFB0 2TGktVmMx6E/z7Gqyy34lTiBVCmzs72HDtKyoveR4BFAVZL0+Lt4vl+svCKBPPTCwAR9 cMZSGqrUfnS+bVLCXRGTVaHO56fh3cpMLGhO8TQGVFuhxPJ8+q+D70B8NkUuAtxFacqo zsYw== X-Gm-Message-State: AEkoouv8N5FkN6WAb9zc1/BT3Ob0lz/cpEjLHNlyJWKeU8n3mNA7NYKAwxqfdwWecADFgg== X-Received: by 10.25.147.197 with SMTP id v188mr3892260lfd.9.1471717997747; Sat, 20 Aug 2016 11:33:17 -0700 (PDT) Received: from [10.92.189.113] ([166.171.56.76]) by smtp.gmail.com with ESMTPSA id 62sm2320325ljj.3.2016.08.20.11.33.15 (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Sat, 20 Aug 2016 11:33:15 -0700 (PDT) References: Mime-Version: 1.0 (1.0) In-Reply-To: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Message-Id: <7503E425-6651-4D40-83FD-592AF580D618@gmail.com> Cc: pgsql-hackers X-Mailer: iPhone Mail (13G34) From: Robert Haas Subject: Re: Should we cacheline align PGXACT? Date: Sat, 20 Aug 2016 14:33:13 -0400 To: Alexander Korotkov X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On Aug 19, 2016, at 2:12 AM, Alexander Korotkov = wrote: > Hackers, >=20 > originally this idea was proposed by Andres Freund while experimenting wi= th lockfree Pin/UnpinBuffer [1]. > The patch is attached as well as results of pgbench -S on 72-cores machin= e. As before it shows huge benefit in this case. > For sure, we should validate that it doesn't cause performance regression= in other cases. At least we should test read-write and smaller machines. > Any other ideas? Wow, nice results. My intuition on why PGXACT helped in the first place wa= s that it minimized the number of cache lines that had to be touched to tak= e a snapshot. Padding obviously would somewhat increase that again, so I ca= n't quite understand why it seems to be helping... any idea? ...Robert --=20 Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers