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?
- Are all unlogged tables in any case truncated after a se... sch8el
- Re: Are all unlogged tables in any case truncated a... David G. Johnston
- Re: Are all unlogged tables in any case truncated a... Laurenz Albe
- Re: Are all unlogged tables in any case truncat... sch8el
- Re: Are all unlogged tables in any case tru... Michael Lewis
- Re: Are all unlogged tables in any case tru... Michael Lewis