Re: error: could not find pg_class tuple for index 2662 - Mailing list pgsql-hackers

daveg <daveg@sonic.net> writes:
> On Thu, Aug 04, 2011 at 04:16:08PM -0400, Tom Lane wrote:
>> If this theory is correct then all of the file-related errors ought to
>> match up to recently-vacuumed mapped catalogs or indexes (those are the
>> ones with relfilenode = 0 in pg_class).  Do you want to expand your
>> logging of the VACUUM FULL actions and see if you can confirm that idea?

> At your service, what would you like to see?

I was thinking log the before-and-after filenode values each time you do
a VACUUM FULL, and then go through the logs to see if all the
file-related complaints refer to recently obsoleted filenodes.
        regards, tom lane