Skip site navigation (1) Skip section navigation (2)

Re: idea: global temp tables

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Greg Stark" <stark(at)enterprisedb(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>,"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>,"PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: idea: global temp tables
Date: 2009-04-29 15:24:42
Message-ID: 49F82AEA.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
Greg Stark <stark(at)enterprisedb(dot)com> wrote: 
 
> The whole point of having the schema declared in advance and then
> having each procedure execution have access to a private (or
> non-private) data store following that predefined schema is to avoid
> having to execute any catalog changes with all the locking and
> catalog i/o that DDL requires.
 
Global temporary tables are not shared between connections.  Look back
to Pavel's original post; he's looking for a convenience -- a way to
have a temporary table materialized for a connection on reference,
"INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES".  It is
not meant to be better in performance than creating a temporary table
explicitly on the fly and adding all these things, it's meant to
provide a consistent definition which can be materialized and used on
demand.  Nothing more; nothing less.  I understand not everyone has a
need for such a thing, but isn't that true of most features in
PostgreSQL?
 
If you're saying we can implement the standard's global temporary
tables in a way that performs better than current temporary tables,
that's cool.  That would be a nice "bonus" in addition to the
application programmer convenience and having another tick-mark on the
standards compliance charts.  Do you think that's feasible?  If not,
the feature would be useful to some with the same performance that
temporary tables currently provide.
 
-Kevin

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-04-29 16:32:10
Subject: Re: GCC 4.4 compiler warnings
Previous:From: Greg StarkDate: 2009-04-29 15:12:03
Subject: Re: idea: global temp tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group