Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL
Date: 2007-07-05 04:01:07
Message-ID: 3407.1183608067@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregory Stark <stark(at)enterprisedb(dot)com> writes:
>> 2007/7/4, Bruce Momjian <bruce(at)momjian(dot)us>:
> The solution is to fix the bloat, not add a work-around.

> The bloat is a direct consequence of performing DDL in the midst of an OLTP
> transaction.

Hardly. It's a consequence of our current implementation of temp
tables; that does not necessarily imply that we cannot fix it without
an API change.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-07-05 04:59:57 Re: script binaries renaming
Previous Message Claudio Rossi 2007-07-05 00:55:57 GRANT ROLE and triggers