Message-ID: <4E1E1CFE.2030500@pinpointresearch.com>
Date: Wed, 13 Jul 2011 15:32:30 -0700
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.17) Gecko/20110516 Lightning/1.0b2 Thunderbird/3.1.10
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org Admin" <pgsql-admin@postgresql.org>
Subject: could not open relation with OID
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I've seen the "could not open relation with OID" error a couple times 
recently and Googling for that error gives responses ranging from *very 
scary* to fuggetaboutit.

The error today occurred running this query which is part of a database 
status reporting script:
select
     pg_size_pretty(sum(pg_relation_size(oid))::bigint) as "Database 
Table Size"
from
   pg_class
where
   relkind = 'r'
;

could not open relation with OID 81285213

Pre-answering some potential questions based on threads I read:

- Version is 8.3 x86_64 (about to be replaced with 9.0).

- Database appears to be functioning fine otherwise and query reran 
without error.

- Size just under 100-million total rows and 12GB (counting tables only).

- Backups completing without error.

- Restore of backup to a twin machine completes without error.

- There are lots of scripts and processes that use temporary tables 
(there are currently 35 pg_temp_XX schemas with the highest being 
pg_temp_55)

So...

Worry or not worry?

Cheers,
Steve