Re: Please help me understand unlogged tables

2018-01-31 Thread Michael Paquier
On Wed, Jan 31, 2018 at 10:52:38AM -0600, Alexander Stoddard wrote: > If a table is set to unlogged is it inherently non-durable? That, is any > crash or unsafe shutdown _must_ result in truncation upon recovery? Yes, they are designed like that. Upon recovery all unlogged tables are

Re: Please help me understand unlogged tables

2018-01-31 Thread Jeff Janes
On Wed, Jan 31, 2018 at 8:52 AM, Alexander Stoddard < alexander.stodd...@gmail.com> wrote: > If a table is set to unlogged is it inherently non-durable? That, is any > crash or unsafe shutdown _must_ result in truncation upon recovery? > Yes. > I can imagine a table that is bulk loaded in a

Please help me understand unlogged tables

2018-01-31 Thread Alexander Stoddard
If a table is set to unlogged is it inherently non-durable? That, is any crash or unsafe shutdown _must_ result in truncation upon recovery? I can imagine a table that is bulk loaded in a warehousing scenario and then sitting statically could be safe, but maybe the question becomes how could the