Tom Lane escribió: > Jim Nasby <[EMAIL PROTECTED]> 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. -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" "La victoria es para quien se atreve a estar solo" ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings