diff options
author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-04-07 18:35:00 -0400 |
---|---|---|
committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-04-07 18:35:00 -0400 |
commit | c6550776394e25c1620bc8258427c8f1d448080d (patch) | |
tree | eb5a62fdc5dcca2911d82af615bac3d36f8cf611 /src/include/access/xlog.h | |
parent | b63c293bcbd7439f883cd4cf748f6755df0fbb3c (diff) | |
download | postgresql-c6550776394e25c1620bc8258427c8f1d448080d.tar.gz postgresql-c6550776394e25c1620bc8258427c8f1d448080d.zip |
Allow users to limit storage reserved by replication slots
Replication slots are useful to retain data that may be needed by a
replication system. But experience has shown that allowing them to
retain excessive data can lead to the primary failing because of running
out of space. This new feature allows the user to configure a maximum
amount of space to be reserved using the new option
max_slot_wal_keep_size. Slots that overrun that space are invalidated
at checkpoint time, enabling the storage to be released.
Author: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com>
Reviewed-by: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Reviewed-by: Álvaro Herrera <alvherre@alvh.no-ip.org>
Discussion: https://postgr.es/m/20170228.122736.123383594.horiguchi.kyotaro@lab.ntt.co.jp
Diffstat (limited to 'src/include/access/xlog.h')
-rw-r--r-- | src/include/access/xlog.h | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/src/include/access/xlog.h b/src/include/access/xlog.h index 7412caa5f22..f60ed2d36cb 100644 --- a/src/include/access/xlog.h +++ b/src/include/access/xlog.h @@ -108,6 +108,7 @@ extern int wal_segment_size; extern int min_wal_size_mb; extern int max_wal_size_mb; extern int wal_keep_segments; +extern int max_slot_wal_keep_size_mb; extern int XLOGbuffers; extern int XLogArchiveTimeout; extern int wal_retrieve_retry_interval; @@ -255,6 +256,17 @@ typedef struct CheckpointStatsData extern CheckpointStatsData CheckpointStats; +/* + * GetWALAvailability return codes + */ +typedef enum WALAvailability +{ + WALAVAIL_INVALID_LSN, /* parameter error */ + WALAVAIL_NORMAL, /* WAL segment is within max_wal_size */ + WALAVAIL_RESERVED, /* WAL segment is reserved by a slot */ + WALAVAIL_REMOVED /* WAL segment has been removed */ +} WALAvailability; + struct XLogRecData; extern XLogRecPtr XLogInsertRecord(struct XLogRecData *rdata, @@ -305,6 +317,8 @@ extern void ShutdownXLOG(int code, Datum arg); extern void InitXLOGAccess(void); extern void CreateCheckPoint(int flags); extern bool CreateRestartPoint(int flags); +extern WALAvailability GetWALAvailability(XLogRecPtr restart_lsn); +extern XLogRecPtr CalculateMaxmumSafeLSN(void); extern void XLogPutNextOid(Oid nextOid); extern XLogRecPtr XLogRestorePoint(const char *rpName); extern void UpdateFullPageWrites(void); |