pgsql: Keep replication slot statistics on invalidation - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Keep replication slot statistics on invalidation
Date
Msg-id E1rjudE-003N7s-5J@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Keep replication slot statistics on invalidation

The code path in charge of invalidating a replication slot includes a
call to pgstat_drop_replslot(), which would result in removing the
statistics of the slot once invalidated.  However, there is no need to
remove the statistics of an invalidated slot as one could still be
interested in looking at them to understand the activity of the slot
until its actual removal.

The initial design of the feature committed in be87200efd used the
approach to drop the slots, which is likely why the statistics were
still removed during the invalidation.

Another problem with this operation is that it was done without holding
ReplicationSlotAllocationLock, leaving it unprotected on concurrent
activity.  This part is arguably a bug, but that's a limited problem in
practice so no backpatch is done.

In passing, this commit adds a test to check this behavior.  The only
remaining code path where slot statistics are dropped now related to the
slot getting dropped.

Author: Bertrand Drouvot
Discussion: https://postgr.es/m/ZermH08Eq6YydHpO@ip-10-97-1-34.eu-west-3.compute.internal

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d6e171fed6c56fc17405445951d5028b7c86a4e3

Modified Files
--------------
src/backend/replication/slot.c                      |  1 -
src/test/recovery/t/035_standby_logical_decoding.pl | 20 ++++++++++++++++++++
2 files changed, 20 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Amit Kapila
Date:
Subject: pgsql: Remove redundant fetch of the recent flush pointer in WalSndWait
Next
From: Alvaro Herrera
Date:
Subject: pgsql: libpq: Move pg_cancel to fe-cancel.c