Re: [HACKERS] Orphaned files in base/[oid]

So having throught about this a bit more, and having had some real-world experience with the script now, I have an idea that might work and some questions to make it succeed.

My thinking is to add a new form of vacuum called VACUUM FSCK.

This would:

1. lock pg_class in exclusive mode (or do I need exclusive access?), as this is needed to solve the race conditions.  As I see, this seems to bring the database to a screeching halt concurrency-wise (but unlike my script would allow other databases to be accessed normally).

2. read the files where the name consists of only digits out of the filesystem and compare with oids from pg_class and relfilenodes

3.  Any file not found in that list would then unlink it, as well as any files with the patter followed by an underscore or period.