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

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Why is a newly created index contains the invalid LSN?
Дата
Msg-id CA+TgmoaWyw8vFxcA3dO3aZxjviRaZRLGbVUciGwup7ZOUoLPCg@mail.gmail.com
обсуждение исходный текст
Ответ на Why is a newly created index contains the invalidLSN?  (Yury Zhuravlev <u.zhuravlev@postgrespro.ru>)
Ответы Re: Why is a newly created index contains the invalid LSN?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: increasing the default WAL segment size
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Why is a newly created index contains the invalid LSN?