From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Adrien Nayrat <adrien(dot)nayrat(at)dalibo(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Christoph Berg <myon(at)debian(dot)org>, Craig Ringer <craig(at)2ndquadrant(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com> |
Subject: | Re: LSN as a recovery target |
Date: | 2016-09-05 07:05:06 |
Message-ID: | CAB7nPqQ5Xj7UiB+sO8wj3Fi6dD3wh23SZxS1Dg_N-PKG7cD3Xw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Sep 5, 2016 at 4:02 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On 5 September 2016 at 06:55, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> wrote:
>> On Sun, Sep 4, 2016 at 11:30 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>
>>> I noticed we don't mention what LSN is anywhere, so I'd like to apply
>>> the following doc patch also.
>>
>> +1 for the idea. What do you think about adding a mention to the
>> system data type pg_lsn?
>>
>> <para>
>> + <acronym>WAL</acronym> records are appended to the <acronym>WAL</acronym>
>> + logs as each new record is written. The insert position is described by
>> + a Log Sequence Number (<acronym>LSN</acronym>) that is a byte offset into
>> + the logs, increasing monotonically with each new record. Two
>> + <acronym>LSN</acronym>s can be compared to calculate the volume of
>> + <acronym>WAL</acronym> data that separates them, so are used to measure
>> + progress of <acronym>WAL</acronym> during replication and recovery.
>> + </para>
>> Here we could for example append a sentence like "The system data type
>> <link linkend="datatype-pg-lsn"><type>pg_lsn</></link> is an internal
>> representation of the LSN".
>
> Good input, thanks. v2 attached.
Looks good to me. Thanks for the wordsmithing.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2016-09-05 07:05:29 | Re: Better locale-specific-character-class handling for regexps |
Previous Message | Simon Riggs | 2016-09-05 07:02:20 | Re: LSN as a recovery target |