Postgres Pro
Downloads
Home   >   mailing lists

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

From Brian Cox
Subject "could not open relation..."
Date
Msg-id 4BBF8357.6010908@ca.com
Whole thread Raw
Responses Re: "could not open relation..."
List pgsql-performance
Tree view 
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
[3358-cemdb-admin-2010-04-09 04:00:19.029 PDT]STATEMENT:  select
lm.ts_login_name,sm.ts_session_id from ts_user_logins_map lm join
ts_user_sessions_map sm on sm.ts_user_id=lm.ts_user_id where not
sm.ts_soft_delete and not lm.ts_soft_delete and lm.ts_user_id != 1 and
lm.ts_app_id in (600000000000000001) order by sm.ts_creation_time

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: 3ware vs. MegaRAID
Next
From: norn
Date:
Subject: Re: significant slow down with various LIMIT