Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Lewis
Subject Re: Are all unlogged tables in any case truncated after a server-using
Date
Msg-id CAHOFxGpea3NSTzv=uyNYCzoikPyChvG7=1kzHJ3p_1NB8t0XFg@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
Tree view
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?

pgsql-general by date:

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