Re: Temp tables

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: bhargav kamineni <kbn98406(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Temp tables
Date: 2018-12-09 20:06:44
Message-ID: CAKFQuwZuLD5Mnsu4pd77BE-wSaL2ayf-zLMkaX8v37fBk9U84g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday, December 9, 2018, bhargav kamineni <kbn98406(at)gmail(dot)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.

In response to

  • Temp tables at 2018-12-09 19:56:45 from bhargav kamineni

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-12-09 20:42:57 Re: Errors with schema migration and logical replication — expected?
Previous Message bhargav kamineni 2018-12-09 19:56:45 Temp tables