Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the use case for UNLOGGED tables - Mailing list pgsql-general

From Ravi Krishna
Subject Re: What is the use case for UNLOGGED tables
Date
Msg-id A4D51983-04DC-49CE-9B6B-78A73E676A2C@aol.com
Whole thread Raw
In response to Re: What is the use case for UNLOGGED tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
>
> I use them for "ELT" oriented processing where the final results get stored on permanently logged tables but I want
tomanipulate 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.
However flipping a normal table between LOGGED and UNLOGGED does not seem to be a use case.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: What is the use case for UNLOGGED tables
Next
From: Tom Lane
Date:
Subject: Re: Best Practices for Extensions, limitations and recommended use for monitoring