Postgres Pro
Downloads
Home   >   mailing lists

Why is a newly created index contains the invalidLSN? - Mailing list pgsql-hackers

From Yury Zhuravlev
Subject Why is a newly created index contains the invalidLSN?
Date
Msg-id 50d99bb5-5770-4815-a564-82f44e0fa0ee@postgrespro.ru
Whole thread Raw
Responses Re: Why is a newly created index contains the invalid LSN?  (Robert Haas <robertmhaas@gmail.com>)
Re: Why is a newly created index contains the invalid LSN?  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: increasing the default WAL segment size
Next
From: Stephen Frost
Date:
Subject: Re: increasing the default WAL segment size