Re: Are all unlogged tables in any case truncated after a server-crash? - Mailing list pgsql-general

From Michael Lewis
Subject Re: Are all unlogged tables in any case truncated after a server-crash?
Date
Msg-id CAHOFxGoyDcthSkJtS0Fg7g6TrLaWj0m1mO8zs8pGV5LizWSKow@mail.gmail.com
Whole thread Raw
In response to Re: Are all unlogged tables in any case truncated after a server-crash?  (sch8el@posteo.de)
List pgsql-general
Curious... why keep the table as unlogged if it is static? If you can spare the disk space, perhaps just create a regular table with same definition, gradually copy the data to spread the impact on WAL, and when complete, just drop the old table and rename the new one.

pgsql-general by date:

Previous
From: Patrick FICHE
Date:
Subject: RE: Replace anonymized data in string
Next
From: Yessica Brinkmann
Date:
Subject: Re: Pg_hba.conf problem after unexpected IP change