Re: increasing the default WAL segment size - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: increasing the default WAL segment size
Date
Msg-id c66c1b54-0c5a-07e6-3ea6-9bd2e0abd1c5@2ndquadrant.com
Whole thread Raw
In response to Re: increasing the default WAL segment size  (Stephen Frost <sfrost@snowman.net>)
Responses Re: increasing the default WAL segment size  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On 3/24/17 08:18, Stephen Frost wrote:
> Peter,
> 
> * Peter Eisentraut (peter.eisentraut@2ndquadrant.com) wrote:
>> There is a function for that.
> [...]
>> There is not a function for that, but there could be one.
> 
> I'm not sure you've really considered what you're suggesting here.

Create a set-returning function that returns all the to-be-expected file
names between two LSNs.

> Beyond that, this also bakes in an assumption that we would then require
> access to a database

That is a good point, but then any change to the naming whatsoever will
create trouble.  Then we might as well choose which specific trouble.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: increasing the default WAL segment size
Next
From: Stephen Frost
Date:
Subject: Re: Monitoring roles patch