From: | David Steele <david(at)pgmasters(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Beena Emerson <memissemerson(at)gmail(dot)com>, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: increasing the default WAL segment size |
Date: | 2017-03-19 16:15:37 |
Message-ID: | 08906cfe-d54c-c6a9-9c15-db0183458e9c@pgmasters.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 3/17/17 4:56 PM, Tom Lane wrote:
> Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> writes:
>> On 3/17/17 16:20, Peter Eisentraut wrote:
>>> I think we would have to extend restore_command with an additional
>>> placeholder that communicates the segment size, and add a new pg_standby
>>> option to accept that size somehow. And specifying the size would have
>>> to be mandatory, for complete robustness. Urgh.
>
>> Another way would be to name the WAL files in a more self-describing
>> way. For example, instead of
>
> Actually, if you're content with having tools obtain this info by
> examining the WAL files, we shouldn't need to muck with the WAL naming
> convention (which seems like it would be a horrid mess, anyway --- too
> much outside code knows that). Tools could get the segment size out of
> XLogLongPageHeaderData.xlp_seg_size in the first page of the segment.
>
> regards, tom lane
+1
--
-David
david(at)pgmasters(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-03-19 17:17:12 | Re: Removing binaries (was: createlang/droplang deprecated) |
Previous Message | David Steele | 2017-03-19 16:06:02 | Re: createlang/droplang deprecated |