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

On 7/3/07, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> Tom Lane escribió:
> > Jim Nasby <decibel(at)decibel(dot)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.
>
> How about a new relkind which causes the table to be located in
> PGDATA/base/<dboid>/pg_temp_<backendid>/<relfilenode>
>
> So each backend can have its own copy of the table with the same
> relfilenode; there's no need for extra catalog entries.
>

we recently make the path for temp files to be just base/pgsql_tmp or
pg_tblspc/<tblspc_oid>/pgsql_tmp. do we want to complicate things
again?

while not just a new rekind indicating this is a template and not and
actual table. and using that template for creating the actual tables?

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook