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
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' |