Re: Where are these tables??

On Fri, 2004-03-26 at 09:28, Patrick Hatcher wrote:

While trying to find the physical disk space size each table in our
database (by matching the file name in the base directory to an entry
in pg_class), we found 4 files that constitute 5gigs that we cannot
match back to a entry in pg_class.
Is it safe to delete these?

I feel like you're holding a gun asking if it's ok to shoot, but you
haven't told us which way it's pointing. I'd be curious to know the
filenames in question and the query your running to look for these
files... might also suggest doing a vacuum full on your cluster to see
if their filesizes change at all... but if you've got that cowboy
feeling going i'd say shutdown the database, backup the directory,
delete the files, and fire it back up...

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL