Truncation of UNLOGGED tables upon restart. - Mailing list pgsql-general

From Ravi Krishna
Subject Truncation of UNLOGGED tables upon restart.
Date
Msg-id 1951433141.20816140.1541105355093@mail.yahoo.com
Whole thread Raw
Responses Re: Truncation of UNLOGGED tables upon restart.
List pgsql-general
Per documentation unlogged tables are not crash safe and PG will truncate it when it restarts after a crash. Does this
applyto 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Add columns to table; insert values based on row
Next
From: Rich Shepard
Date:
Subject: Re: Add columns to table; insert values based on row