Re: Where are these tables??
От | Robert Treat |
---|---|
Тема | Re: Where are these tables?? |
Дата | |
Msg-id | 1080317329.27332.494.camel@camel обсуждение исходный текст |
Ответ на | Where are these tables?? ("Patrick Hatcher" <PHatcher@macys.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: