Re: POC: Cache data in GetSnapshotData()

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org,Robert Haas <robertmhaas(at)gmail(dot)com>,Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>,pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: POC: Cache data in GetSnapshotData()
Date: 2017-09-21 02:32:36
Message-ID: CB10979C-1FB1-42DA-A322-5E8D1541927A@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On September 20, 2017 7:22:00 PM PDT, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>On Wed, Sep 20, 2017 at 10:04 PM, Mithun Cy
><mithun(dot)cy(at)enterprisedb(dot)com> wrote:
>> My current tests show on scylla (2 socket machine with 28 CPU core) I
>> do not see any improvement at all as similar to Jesper. But same
>tests
>> on power2 (4 sockets) and Cthulhu(8 socket machine) we can see
>> improvements.
>
>OK, makes sense. So for whatever reason, this appears to be something
>that will only help users with >2 sockets. But that's not necessarily
>a bad thing.

Wonder how much of that is microarchitecture, how much number of sockets.

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Lukas Fittl 2017-09-21 03:27:05 Re: [BUGS] BUG #14821: idle_in_transaction_session_timeout sometimes gets ignored when statement timeout is pending
Previous Message Andrew Dunstan 2017-09-21 02:26:42 Re: Windows warnings from VS 2017