Re: Forward zeroing of pg_clog

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Forward zeroing of pg_clog
Дата
Msg-id NOEFLCFHBPDAFHEIPGBOAEKLCDAA.simon@2ndquadrant.com
обсуждение исходный текст
Ответ на Forward zeroing of pg_clog  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Forward zeroing of pg_clog  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Tom Lane wrote

> This is already true at the page level: when advancing into a new page
> we zero it instead of reading anything from disk.  I am thinking of
> adding code to StartupCLOG to zero the remaining portion of the
> "current" page too.
>
> Thoughts?
>

That sounds like the right thing to do. IIRC that means we do it once at the
very end of recovery, which is quick as well as safe.

This is important for point-in-time recovery also, since there would always
be clog entries ahead of the recovery target.

Best Regards, Simon Riggs



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Data point on the competition regarding selectivity of unknown parameters
Следующее
От: Fabien COELHO
Дата:
Сообщение: open item: tablespace handing in pg_dump/pg_restore