Cache lookup failed, and then it doesn't

From: arne(at)easyconnect(dot)no (Arne Wulvik)
To: pgsql-general(at)postgresql(dot)org
Subject: Cache lookup failed, and then it doesn't
Date: 2003-05-09 09:26:05
Message-ID: b7b9a45f.0305090126.2c17fb66@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've got a rather curious problem with my postgresql 7.3.2
installation (running on BSD on an Intel platform):

Every once in a while I receive the message 'Cache lookup failed for
relation xxxx' - even when I just try to list my tables using \d

However, when I issue the same command again - immediatly afterwards
in the same session - the query runs fine.

The entire database (30M+ records) is recreated on a daily basis
(tables truncated, vacuumed, reloaded and analyzed).

This is rather bad, as it's a production database running a telephone
directory service and sometimes gives our operators the impression
that their queries didn't find anything, and we lose a customer.

Any ideas?

Regards

Arne Wulvik

Browse pgsql-general by date

  From Date Subject
Next Message Markus.Schmitz 2003-05-09 10:03:52 Rule on tabel
Previous Message Terry Yapt 2003-05-09 07:59:03 Re: pg_dump options and perhaps 'Enhancement request'