From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Patch to remove sort files, temp tables, unreferenced files |
Date: | 2001-05-28 19:17:32 |
Message-ID: | 200105281917.f4SJHW616700@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
The following patch does full referential checking of sort files, temp
tables, and table files. It checks references of every file and temp
table, and reports or removes it. The code only removes files it is
certain about.
A typical output report is:
test=> VACUUM;
NOTICE: Unusual file found in temporary sort directory. This file is not
normally created by PostgreSQL and can be removed by the
administrator using 'rm':
/usr/var/local/postgres/data/base/18617/pg_sorttemp/x
NOTICE: Unusual file found in database directory. This file is not
normally created by PostgreSQL and can be removed by the
administrator using 'rm':
/usr/var/local/postgres/data/base/18617/x
NOTICE: Core file found in database directory. If you don't need it
for debugging, the administrator can remove it using 'rm':
/usr/var/local/postgres/data/base/18617/core
NOTICE: Unreferenced table file found in database directory. This
could have been left from a database crash. If no one was
using the database during VACUUM, the file can be safely
removed by the administrator using 'rm':
/usr/var/local/postgres/data/base/18617/33333
Most of the work is done as part of a full database VACUUM. Postmaster
startup also cleans all sort files.
It uses a SnapshotAny read of pg_class to find referenced files. It
does not use Oid ranges anymore.
I also had to add ShmemPIDAdd() and redo ShmemPIDLookup() because the
ShmemPIDLookup() API was weird.
--
Bruce Momjian | http://candle.pha.pa.us
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
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 22.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Lance Taylor | 2001-05-28 22:47:24 | Re: [HACKERS] Support for %TYPE in CREATE FUNCTION |
Previous Message | Bruce Momjian | 2001-05-28 14:15:23 | Re: [HACKERS] Support for %TYPE in CREATE FUNCTION |