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

From Tatsuo Ishii
Subject Re: GLOBAL vs LOCAL temp tables
Date
Msg-id 20030417.102124.71088282.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: GLOBAL vs LOCAL temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: GLOBAL vs LOCAL temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
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?

No problem with the testing. Let me report later.

BTW, do you have any document for the btree compaction logic you have
implemented? I see your proposal in the mailing list, but not sure
about your actual implementaion...
--
Tatsuo Ishii



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: encoding question
Next
From: Kevin Brown
Date:
Subject: Re: GLOBAL vs LOCAL temp tables