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

Orphaned files in the database...

From: Kristofer Munn <kmunn(at)munn(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Orphaned files in the database...
Date: 2000-01-27 23:03:05
Message-ID: Pine.LNX.4.04.10001271800100.1275-100000@munn.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi all!

Beating on the Postgresql database v6.5.3 on my Intel machine, I find lots
of orphaned tables in my database's directory such as:

	pg_sorttemp#####.#
	pg_temp.#####.#

I know temp tables have been changed drastically in V7.0 and cleaned up (I
can't wait since I use them extensively).  I was wondering if VACUUM has
been altered to clean the data directory of stale/useless files such as
those above.  If not, I think this might be an important feature.

- K

Kristofer Munn * KMI * 973-509-9414 * AIM KrMunn * http://www.munn.com/


pgsql-hackers by date

Next:From: Tom LaneDate: 2000-01-27 23:09:26
Subject: Re: [HACKERS] Length of OID
Previous:From: Peter EisentrautDate: 2000-01-27 22:28:44
Subject: TODO list check

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