Postgres Pro
Downloads
Home   >   mailing lists

Re: Introduce MIN/MAX aggregate functions to pg_lsn - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Introduce MIN/MAX aggregate functions to pg_lsn
Date
Msg-id 20190704081717.GQ3084@paquier.xyz
Whole thread Raw
In response to Re: Introduce MIN/MAX aggregate functions to pg_lsn  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Responses Re: Introduce MIN/MAX aggregate functions to pg_lsn  (Robert Haas <robertmhaas@gmail.com>)
Re: Introduce MIN/MAX aggregate functions to pg_lsn  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Jul 02, 2019 at 11:31:49AM -0300, Fabrízio de Royes Mello wrote:
> New version attached.

This looks in pretty good shape to me, and no objections from me to
get those functions as the min() flavor is useful for monitoring WAL
retention for complex deployments.

Do you have a particular use-case in mind for max() one?  I can think
of at least one case: monitoring the flush LSNs of a set of standbys
to find out how much has been replayed at most.
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: extension patch of CREATE OR REPLACE TRIGGER
Next
From: Julien Rouhaud
Date:
Subject: Re: pg_waldump and PREPARE