idea for 8.4. using partitioning for temporary tables?

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org>
Subject: idea for 8.4. using partitioning for temporary tables?
Date: 2007-12-15 18:40:33
Message-ID: 162867790712151040r1f8b4897ldd2b2a62588025d2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-12-15 19:33:00 Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node
Previous Message Andrew Dunstan 2007-12-15 17:50:33 Re: pgwin32_open returning EINVAL