Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Should we cacheline align PGXACT? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [HACKERS] Should we cacheline align PGXACT?
Date
Msg-id CANP8+jKkJAm+tbg5mwFrs2D-t-u_o9oLk=3My-=JVfMXmtv9aw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Should we cacheline align PGXACT?  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] Should we cacheline align PGXACT?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On 15 February 2017 at 19:15, Andres Freund <andres@anarazel.de> wrote:

> I think I previously
> mentioned, even just removing the MyPgXact->xmin assignment in
> SnapshotResetXmin() is measurable performance wise and cache-hit ratio
> wise.

Currently, we issue SnapshotResetXmin() pointlessly at end of xact, so
patch attached to remove that call, plus some comments to explain
that. This reduces the cause.

Also, another patch to reduce the calls to SnapshotResetXmin() using a
simple heuristic to reduce the effects.

-- 
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: [HACKERS] SCRAM authentication, take three
Next
From: Aleksander Alekseev
Date:
Subject: Re: [HACKERS] SCRAM authentication, take three