Postgres Pro
Downloads
Home   >   mailing lists

Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL
Date
Msg-id 3407.1183608067@sss.pgh.pa.us
Whole thread Raw
In response to Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Tree view 
Gregory Stark <stark@enterprisedb.com> writes:
>> 2007/7/4, Bruce Momjian <bruce@momjian.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

pgsql-hackers by date:

Previous
From: "Claudio Rossi"
Date:
Subject: GRANT ROLE and triggers
Next
From: Gregory Stark
Date:
Subject: Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL