Re: Temp tables - Mailing list pgsql-general

From David G. Johnston
Subject Re: Temp tables
Date
Msg-id CAKFQuwZuLD5Mnsu4pd77BE-wSaL2ayf-zLMkaX8v37fBk9U84g@mail.gmail.com
Whole thread Raw
In response to Temp tables  (bhargav kamineni <kbn98406@gmail.com>)
Responses Re: Temp tables  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
On Sunday, December 9, 2018, bhargav kamineni <kbn98406@gmail.com> wrote:
What happens if we create and insert/update the data in TEMP tables , Does that data really gets inserted at disk level or at buffer level

Disk 
 
 and what happens to this data after completion of the transaction ?

Your choice. See “on conflict” clause of create temp table command.

David J.
 

pgsql-general by date:

Previous
From: bhargav kamineni
Date:
Subject: Temp tables
Next
From: Adrian Klaver
Date:
Subject: Re: Errors with schema migration and logical replication — expected?