Why is a newly created index contains the invalid LSN?

From: Yury Zhuravlev <u(dot)zhuravlev(at)postgrespro(dot)ru>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Why is a newly created index contains the invalid LSN?
Date: 2016-08-25 14:25:17
Message-ID: 50d99bb5-5770-4815-a564-82f44e0fa0ee@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello hackers.

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?

Thanks.

--
Yury Zhuravlev
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2016-08-25 14:34:58 Re: increasing the default WAL segment size
Previous Message Robert Haas 2016-08-25 14:18:52 Re: increasing the default WAL segment size