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
pgsql-hackers by date
| Next: | From: Don Baccus | Date: 2000-04-06 17:11:54 |
| Subject: Re: Book and TEMP vs. TEMPORARY |
| Previous: | From: Thomas Lockhart | Date: 2000-04-06 16:45:39 |
| Subject: Re: Book and TEMP vs. TEMPORARY |