Truncation of UNLOGGED tables upon restart.

From: Ravi Krishna <srkrishna1(at)aol(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Truncation of UNLOGGED tables upon restart.
Date: 2018-11-01 20:49:15
Message-ID: 1951433141.20816140.1541105355093@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2018-11-01 20:50:39 Re: Add columns to table; insert values based on row
Previous Message David G. Johnston 2018-11-01 20:34:32 Re: Add columns to table; insert values based on row