Re: "could not open relation..." - Mailing list pgsql-performance

From Tom Lane
Subject Re: "could not open relation..."
Date
Msg-id 21663.1270873746@sss.pgh.pa.us
Whole thread Raw
In response to "could not open relation..."  (Brian Cox <brian.cox@ca.com>)
List pgsql-performance
Brian Cox <brian.cox@ca.com> writes:
> I saw this in the postgres log. Anyone know what would cause this?
> Thanks, Brian

> postgres 8.3.5 on RHEL4 update 6

> [3358-cemdb-admin-2010-04-09 04:00:19.029 PDT]ERROR:  could not open
> relation with OID 170592

Seems a bit off-topic for pgsql-performance, but anyway: the main
known cause for that is if one of the tables used in the query got
dropped (by another session) just after the query started.  Could
that have happened to you?

            regards, tom lane

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: About “context-switching issue on Xeon” test case ?
Next
From: Scott Marlowe
Date:
Subject: Re: [PERFORM] About “context-switching issue on Xeon” test case ?