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