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: (view raw or whole 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);
	test=> vacuum test;
	NOTICE:  Vacuum: table not found

  Bruce Momjian                        |
  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-2015 The PostgreSQL Global Development Group