Postgres Pro
Downloads
Home   >   mailing lists

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

From Tatsuo Ishii
Subject Re: GLOBAL vs LOCAL temp tables
Date
Msg-id 20030416.100938.104029572.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  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: GLOBAL vs LOCAL temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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.
--
Tatsuo Ishii

pgsql-hackers by date:

Previous
From: Sailesh Krishnamurthy
Date:
Subject: Re: Are we losing momentum?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: encoding question