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
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 |