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 :
http://o.ptimized.com/
615-260-0005
"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