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

From Alvaro Herrera
Subject Re: GLOBAL vs LOCAL temp tables
Date
Msg-id 20030416030543.GB6483@dcc.uchile.cl
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  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: GLOBAL vs LOCAL temp tables  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
On Wed, Apr 16, 2003 at 10:09:38AM +0900, Tatsuo Ishii wrote:
> 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.

This is fixed in 7.4 already.  It wasn't a problem with temp tables, but
with btree indexes.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Endurecerse, pero jamas perder la ternura" (E. Guevara)



pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: Foreign Database Connectivity
Next
From: Bruce Momjian
Date:
Subject: Re: GLOBAL vs LOCAL temp tables