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

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: sch8el(at)posteo(dot)de
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)postgresql(dot)org
Subject: Re: Are all unlogged tables in any case truncated after a server-crash?
Date: 2021-11-12 17:31:27
Message-ID: CAHOFxGoyDcthSkJtS0Fg7g6TrLaWj0m1mO8zs8pGV5LizWSKow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yessica Brinkmann 2021-11-12 18:34:40 Re: Pg_hba.conf problem after unexpected IP change
Previous Message Patrick FICHE 2021-11-12 15:21:18 RE: Replace anonymized data in string