Vacuuming temporary tables

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Vacuuming temporary tables
Date: 2000-04-06 17:10:12
Message-ID: 200004061710.NAA24871@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Seems temporary tables can not be vacuumed. It is because vacuum.c does
a sequential scan of the pg_class table, rather than using the cache.
Should this be fixed?

test=> create temporary table test (x integer);
CREATE
test=> vacuum test;
NOTICE: Vacuum: table not found
VACUUM

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 2000-04-06 17:11:54 Re: Book and TEMP vs. TEMPORARY
Previous Message Thomas Lockhart 2000-04-06 16:45:39 Re: Book and TEMP vs. TEMPORARY