Temp tables
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
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.
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