Postgres Pro
Downloads
Home   >   mailing lists

Re: Why is a newly created index contains the invalid LSN? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Why is a newly created index contains the invalid LSN?
Date
Msg-id CA+TgmoaWyw8vFxcA3dO3aZxjviRaZRLGbVUciGwup7ZOUoLPCg@mail.gmail.com
Whole thread Raw
In response to Why is a newly created index contains the invalidLSN?  (Yury Zhuravlev <u.zhuravlev@postgrespro.ru>)
Responses Re: Why is a newly created index contains the invalid LSN?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On Thu, Aug 25, 2016 at 10:25 AM, Yury Zhuravlev
<u.zhuravlev@postgrespro.ru> wrote:
> I have a small question. While working on an incremental backup I noticed a
> strange thing.
> Newly created index is contains the invalid LSN (0/0).
> Exmaple:
> postgres=# select lsn from page_header(get_raw_page('test_a_idx2',0));
> lsn -----
> 0/0
> (1 row)
>
> Can you explain me why?

Why not?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: increasing the default WAL segment size
Next
From: Robert Haas
Date:
Subject: Re: Why is a newly created index contains the invalid LSN?