Hello I am thinking about global temporary tables. Current problem is frequent modification some system tables pg_class, pg_attribute and others. We need merge metadata for real tables and for temporary tables. Currently we use metadata of temp tables like metadata of normal tables with known problems.
Idea: We will use partitioning for there system tables. Every tables will have two parts: one real, and second virtual. For virtual part we need some like memory tables. On session start we only create these memory parts and when we finish then we free these parts. This mechanism doesn't need any vacuum. What do you thing about it? Regards Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
