Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group