Move PinBuffer and UnpinBuffer to atomics

From: YUriy Zhuravlev <u(dot)zhuravlev(at)postgrespro(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Move PinBuffer and UnpinBuffer to atomics
Date: 2015-09-11 10:23:24
Message-ID: 2400449.GjM57CE0Yg@dinodell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hello hackers!

Continuing the theme:

This time, we fairly rewrote 'refcount' and 'usage_count' to atomic in
PinBuffer and UnpinBuffer (but save lock for buffer flags in Unpin).

In the same time it doesn't affect to correctness of buffer manager
because that variables already have LWLock on top of them (for partition of
hashtable). If someone pinned buffer after the call StrategyGetBuffer we just
try again (in BufferAlloc). Also in the code there is one more check before
deleting the old buffer, where changes can be rolled back. The other functions
where it is checked 'refcount' and 'usage_count' put exclusive locks.

Also stress test with 256 KB shared memory ended successfully.

Without patch we have 417523 TPS and with patch 965821 TPS for big x86 server.
All details here:

Thank you.
YUriy Zhuravlev
Postgres Professional:
The Russian Postgres Company

Attachment Content-Type Size
atomic_bufmgr_v5.patch text/x-patch 12.5 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2015-09-11 10:25:10 Re: proposal: function parse_ident
Previous Message Etsuro Fujita 2015-09-11 10:22:56 Comment update to pathnode.c