5 ms·
UNLOGGED tables is new to me, thanks for sharing.
by teej 6y ago
UNLOGGED tables is new to me, thanks for sharing.
- jacques_chester 6y agoIt's tremendously useful for ETL.
- cpard 6y agoThat's super interesting. Can you share some more information on why it's so useful for ETL?
- djur 6y agoThink of it as a temporary table that doesn't automatically disappear at the end of the session. If nothing but your ETL process cares about the data until it's done being processed, and you still have the original data until the processing is done, in the worst case scenario (the server crashing) you just have to start your ETL process from the start.