Re: Temp tables

2018-12-10 Thread Laurenz Albe
David G. Johnston wrote: > > and what happens to this data after completion of the transaction ? > > > > Your choice. See “on conflict” clause of create temp table command. You mean the ON COMMIT clause. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com

Re: Temp tables

2018-12-09 Thread David G. Johnston
On Sunday, December 9, 2018, bhargav kamineni 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