Truncation of UNLOGGED tables upon restart.

Поиск
Список
Период
Сортировка
Искать
От
Ravi Krishna
Тема
Truncation of UNLOGGED tables upon restart.
Дата
Msg-id
1951433141.20816140.1541105355093@mail.yahoo.com
Список
Дерево обсуждения
Truncation of UNLOGGED tables upon restart. Ravi Krishna <srkrishna1@aol.com>
Re: Truncation of UNLOGGED tables upon restart. "David G. Johnston" <david.g.johnston@gmail.com>
Re: Truncation of UNLOGGED tables upon restart. Ravi Krishna <srkrishna1@aol.com>
Re: Truncation of UNLOGGED tables upon restart. Stephen Frost <sfrost@snowman.net>
Re: Truncation of UNLOGGED tables upon restart. Michael Paquier <michael@paquier.xyz>
Re: Truncation of UNLOGGED tables upon restart. Stephen Frost <sfrost@snowman.net>
Re: Truncation of UNLOGGED tables upon restart. Ron <ronljohnsonjr@gmail.com> 
Per documentation unlogged tables are not crash safe and PG will truncate it when it restarts after a crash. Does this apply to even read only unlogged tables.

For example:

On Monday I load data into unlogged tables.

Then from Tue onwards the table is only read by application.

On Fri morning PG crashes.  When it restarts will it truncate all unlogged tables even though they remained
unchanged.  I hope it does not.
В списке pgsql-general по дате отправления
Предыдущее
От: David G. Johnston
Дата:
Следующее
От: Rich Shepard
Дата:
FAQ