Re: "could not open relation..."

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Cox <brian(dot)cox(at)ca(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: "could not open relation..."
Date: 2010-04-10 04:29:06
Message-ID: 21663.1270873746@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Brian Cox <brian(dot)cox(at)ca(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message norn 2010-04-10 04:41:55 Re: significant slow down with various LIMIT
Previous Message Greg Smith 2010-04-10 04:02:35 Re: About “context-switching issue on Xeon” test case ？