From: Steve Crawford <scrawford@pinpointresearch.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org Admin <pgsql-admin@postgresql.org>
Subject: Re: could not open relation with OID
Date: Wed, 13 Jul 2011 16:51:28 -0700
Message-ID: <4E1E2F80.30709@pinpointresearch.com> (raw)
In-Reply-To: <12791.1310599941@sss.pgh.pa.us>
References: <4E1E1CFE.2030500@pinpointresearch.com>
<12791.1310599941@sss.pgh.pa.us>
On 07/13/2011 04:32 PM, Tom Lane wrote:
> Steve Crawford<scrawford@pinpointresearch.com> writes:
>> I've seen the "could not open relation with OID" error a couple times
>> recently ...
> Not worry....
> You might be able to dodge the problem by excluding temp relations from
> the reporting query, though whether the sum of only non-temp rel sizes
> is of value to you is hard to guess from here.
Data safety was my concern. The error is so rare that I can ignore it.
(The two I saw are the first in the 2+ years this server has been active
and were probably the result of running the report manually when the
database was active rather than the usual nighttime cron-run).
Cheers,
Steve
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, tgl@sss.pgh.pa.us
Subject: Re: could not open relation with OID
In-Reply-To: <4E1E2F80.30709@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox