Обсуждение: Temp tables

Поиск
Список
Период
Сортировка

Temp tables

От
bhargav kamineni
Дата:
Hi,

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 and what happens to this data after completion of the transaction ?



Thanks
Banu

Re: Temp tables

От
"David G. Johnston"
Дата:
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.
 

Re: Temp tables

От
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