Re: Large Database \d: ERROR: cache lookup failed for relation ...

"Thomas F. O'Connell" <tf@o.ptimized.com> writes:
> I'm dealing with a database where there are ~150,000 rows in
> information_schema.tables. I just tried to do a \d, and it came back
> with this:

> ERROR:  cache lookup failed for relation [oid]

> Is this indicative of corruption, or is it possibly a resource issue?

It'd not be unexpected if other transactions were concurrently dropping
tables.  If it's persistent (with the same OID mentioned) then you need
to worry.

            regards, tom lane