Re: GLOBAL vs LOCAL temp tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: GLOBAL vs LOCAL temp tables
Date
Msg-id 18501.1050507710@sss.pgh.pa.us
Whole thread Raw
In response to Re: GLOBAL vs LOCAL temp tables  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: GLOBAL vs LOCAL temp tables  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> The real problem with current temp tables is the implementation. I see
> very quick growth of system catalogs with heavy use of temp
> tables(some hundred mega bytes per week on a busy system for
> example). To fix the system catalogs, we have to stop postmaster and
> have to do reindex. This is truly a pain.

I believe the btree compaction logic in CVS tip will fix this.
It would be nice to see in-the-field proof though.  Don't suppose you
want to run a test system with CVS tip?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Rob Butler
Date:
Subject: Many comments (related to "Are we losing momentum?")
Next
From: Sean Chittenden
Date:
Subject: Re: Are we losing momentum?