From: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Cc: | thomas(dot)munro(at)enterprisedb(dot)com, sk(at)zsrv(dot)org, michael(dot)paquier(at)gmail(dot)com, andres(at)anarazel(dot)de, peter(dot)eisentraut(at)2ndquadrant(dot)com |
Subject: | Re: [HACKERS] Restricting maximum keep segments by repslots |
Date: | 2018-06-26 07:26:59 |
Message-ID: | 20180626.162659.223208514.horiguchi.kyotaro@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello. This is the reabased version of slot-limit feature.
This patch limits maximum WAL segments to be kept by replication
slots. Replication slot is useful to avoid desync with replicas
after temporary disconnection but it is dangerous when some of
replicas are lost. The WAL space can be exhausted and server can
PANIC in the worst case. This can prevent the worst case having a
benefit from replication slots using a new GUC variable
max_slot_wal_keep_size.
This is a feature mentioned in the documentation.
https://www.postgresql.org/docs/current/static/warm-standby.html#STREAMING-REPLICATION-SLOTS
> In lieu of using replication slots, it is possible to prevent the
> removal of old WAL segments using wal_keep_segments, or by
> storing the segments in an archive using
> archive_command. However, these methods often result in retaining
> more WAL segments than required, whereas replication slots retain
> only the number of segments known to be needed. An advantage of
> these methods is that they bound the space requirement for
> pg_wal; there is currently no way to do this using replication
> slots.
The previous patche files doesn't have version number so I let
the attached latest version be v2.
v2-0001-Add-WAL-releaf-vent-for-replication-slots.patch
The body of the limiting feature
v2-0002-Add-monitoring-aid-for-max_replication_slots.patch
Shows the status of WAL rataining in pg_replication_slot view
v2-0003-TAP-test-for-the-slot-limit-feature.patch
TAP test for this feature
v2-0004-Documentation-for-slot-limit-feature.patch
Documentation, as the name.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
Attachment | Content-Type | Size |
---|---|---|
v2-0004-Documentation-for-slot-limit-feature.patch | text/x-patch | 5.3 KB |
v2-0003-TAP-test-for-the-slot-limit-feature.patch | text/x-patch | 5.3 KB |
v2-0002-Add-monitoring-aid-for-max_replication_slots.patch | text/x-patch | 8.9 KB |
v2-0001-Add-WAL-releaf-vent-for-replication-slots.patch | text/x-patch | 7.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2018-06-26 07:37:28 | Re: partition tree inspection functions |
Previous Message | Jeevan Ladhe | 2018-06-26 07:22:44 | Re: "Access privileges" is missing after pg_dumpall |