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 19728.1183394601@sss.pgh.pa.us
Whole thread Raw
In response to Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL  (Jim Nasby <decibel@decibel.org>)
Responses Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
Jim Nasby <decibel@decibel.org> writes:
> I've often thought that having global temp tables would be a really  
> good idea, since it would drastically reduce the need to vacuum  
> catalog tables,

I rather doubt that.  The most likely implementation would involve
cloning a "template" entry into pg_class.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Configurable Additional Stats
Next
From: Tom Lane
Date:
Subject: Re: Configurable Additional Stats