Re: [GENERAL] Unlogged Crash Detection

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] Unlogged Crash Detection
Дата
Msg-id CAB7nPqQJqA=xDENt-XAijhPbizgZ6YfXpErHgqjuwxoDoLUV6A@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Unlogged Crash Detection  (Gersner <gersner@gmail.com>)
Ответы Re: [GENERAL] Unlogged Crash Detection
Список pgsql-general
On Tue, Aug 29, 2017 at 5:17 PM, Gersner <gersner@gmail.com> wrote:
> Is there a reliable way to distinguish between an empty unlogged table to an
> unlogged table which has been truncated due to a crash?

Why do you want to make such a difference? At the beginning of a crash
recovery all the, the existing relation files of unlogged tables are
all removed, and replaced by the init forknum which represents their
initial state. You can see by yourself ResetUnloggedRelations &
friends in reinit.c.
--
Michael


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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: [GENERAL] Performance with high correlation in group by on PK
Следующее
От: Gersner
Дата:
Сообщение: Re: [GENERAL] Unlogged Crash Detection