Re: Why is a newly created index contains the invalid LSN?

On 8/26/16 4:17 PM, Andres Freund wrote:
> On 2016-08-26 18:46:42 +0300, Yury Zhuravlev wrote:
>> Thanks all.
>> Now understand LSN strongly connected with WAL.
>> However how difficult put last system LSN instead 0?
>> It's not so important but will allow make use LSN more consistent.
>
> Maybe explain why you're interested in page lsns, that'd perhaps allow
> us to give more meaningful feedback.

Yeah, especially since you mentioned this being for backups. I suspect 
you *want* those WAL records marked with 0, because that tells you that 
you can't rely on WAL when you back that data up.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461