pgsql: Rework MultiXactId cache code - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Rework MultiXactId cache code
Date
Msg-id E1VrZH7-0003AX-Jl@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Rework MultiXactId cache code

The original performs too poorly; in some scenarios it shows way too
high while profiling.  Try to make it a bit smarter to avoid excessive
cosst.  In particular, make it have a maximum size, and have entries be
sorted in LRU order; once the max size is reached, evict the oldest
entry to avoid it from growing too large.

Per complaint from Andres Freund in connection with new tuple freezing
code.

Branch
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/0bc00363b9b1d5ee44a0b25ed2dfc83f81e68258

Modified Files
--------------
src/backend/access/transam/multixact.c |   52 ++++++++++++++++++++++++++------
1 file changed, 42 insertions(+), 10 deletions(-)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Rework MultiXactId cache code
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Fix typo