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

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 <pgsql-general(at)postgresql(dot)org>
Subject: Re: Are all unlogged tables in any case truncated after a server-using
Date: 2021-11-12 14:00:42
Message-ID: CAHOFxGpea3NSTzv=uyNYCzoikPyChvG7=1kzHJ3p_1NB8t0XFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Why keep them as unlogged tables? If data is static, can you spare the disk
space to gradually copy data from existing unlogged table to new copy that
is logged, and then have brief exclusive lock to drop unlogged and rename
new one?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick FICHE 2021-11-12 14:12:33 Replace anonymized data in string
Previous Message Dave Cramer 2021-11-12 12:22:38 Re: Pg_hba.conf problem after unexpected IP change