Re: What is the use case for UNLOGGED tables

2018-08-14 Thread Ravi Krishna
> > I use them for "ELT" oriented processing where the final results get stored > on permanently logged tables but I want to manipulate tables while > transforming from the original input. Yeah I see the use case. Basically raw data -> rolled up data -> to final results in normal tables. Howe

Re: What is the use case for UNLOGGED tables

2018-08-14 Thread David G. Johnston
On Tuesday, August 14, 2018, Ravi Krishna wrote: > Then what exactly is the benefit of UNLOGGED tables, unless we have > permanent unlogged tables for disposable > data. > I use them for "ELT" oriented processing where the final results get stored on permanently logged tables but I want to manip

What is the use case for UNLOGGED tables

2018-08-14 Thread Ravi Krishna
I am trying to understand the use case for UNLOGGED tables in PG. I am specifically talking about normal tables which need to be turned into UNLOGGED for a specific purpose like bulk loading because generating WAL logs during the load makes no sense, even when we take into consideration that