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

VACUUM of temp tables

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: VACUUM of temp tables
Date: 2000-04-06 18:02:19
Message-ID: 200004061802.OAA00453@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Fixed:

	test=> CREATE TEMPORARY TABLE test(x int);
	CREATE
	test=> VACUUM test;
	VACUUM

Look at the comment I found in the code:

        /*
         * we could use the cache here, but it is clearer to use scankeys
         * for both vacuum cases, bjm 2000/01/19
         */

Seems I had already looked at this as an issue.  I had not realized
this was an issue for temp tables.  Fixed now.

-- 
  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: Bruce MomjianDate: 2000-04-06 18:05:55
Subject: Re: pg_dumplo, thanks :) (fwd)
Previous:From: Bruce MomjianDate: 2000-04-06 17:55:16
Subject: Re: Vacuuming temporary tables

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