Re: Unable to determine what has a particular OID

Поиск
Список
Период
Сортировка
От Andy Dale
Тема Re: Unable to determine what has a particular OID
Дата
Msg-id AANLkTincFvPgp4vJ1Ip0pIf7R4e78OiOJJSh4IOOK2PQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unable to determine what has a particular OID  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Unable to determine what has a particular OID  (Andy Dale <andy.dale@gmail.com>)
Список pgsql-general
On 18 June 2010 16:37, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Andy Dale <andy.dale@gmail.com> writes:
> On 18 June 2010 16:06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> You should be looking at pg_class.relfilenode, not OID.  See
>> http://www.postgresql.org/docs/8.3/static/storage.html

> Ok, but when I have dumped the pg_class table into a file like so:
> ...
> Grep-ing  for the correct oid/filenode (110660 in my case), nothing is
> returned.

Hm.  You're sure you're looking at pg_class in the right database?

If there really isn't a pg_class entry matching that relfilenode,
then the files are orphans and can be removed.  There are some scenarios
where orphan files can be left behind, but they generally involve
database crashes ... have you had any of those?

                       regards, tom lane

To the best of my knowledge we have not had any DB crashes as yet.  I am also replicating the DB using slony, could this be the cause of these weird orphans ? (it is neither of the sl_log_ tables)

В списке pgsql-general по дате отправления:

Предыдущее
От: Andy Dale
Дата:
Сообщение: Re: Unable to determine what has a particular OID
Следующее
От: Vick Khera
Дата:
Сообщение: Re: Excessive Deadlocks On Concurrent Inserts to Shared Parent Row