Pavel Stehule escribió: > Hello > > I am thinking about global temp tables. One possible solution is > creating global temporary table like normal table and in planner stage > check using this table. When some global temporary table is detected, > then real temporary table is created and used in execution plan. It's > like: > > CREATE GLOBAL TEMP TABLE foo(a varchar); -- create global empty table foo > SELECT * FROM foo; > a) is relevant temp table for foo, use it > a) when not, then CREATE TEMP TABLE pg_temp_1.foo(LIKE foo INCLUDING > DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES); > b) transform origin query to SELECT * FROM pg_temp_1.foo; > > Ideas? Notes? Objections?
Maybe we could make this work by fiddling with a different smgr -- on it, smgr_sync would be a noop, as would smgr_immedsync, and we could kludge something up to truncate relations during recovery. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
