Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] POC: Cache data in GetSnapshotData() - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] POC: Cache data in GetSnapshotData()
Date
Msg-id CB10979C-1FB1-42DA-A322-5E8D1541927A@anarazel.de
Whole thread Raw
In response to Re: [HACKERS] POC: Cache data in GetSnapshotData()  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] POC: Cache data in GetSnapshotData()  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 

On September 20, 2017 7:22:00 PM PDT, Robert Haas <robertmhaas@gmail.com> wrote:
>On Wed, Sep 20, 2017 at 10:04 PM, Mithun Cy
><mithun.cy@enterprisedb.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.


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] Windows warnings from VS 2017
Next
From: Lukas Fittl
Date:
Subject: [HACKERS] Re: [BUGS] BUG #14821: idle_in_transaction_session_timeout sometimesgets ignored when statement timeout is pending