Thread: Large Database \d: ERROR: cache lookup failed for relation ...
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?
I don't see a lot of evidence of this error in the archives.
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
"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