pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Raf <rafiq@joshua.dreamthought.com>
To: pgsql-admin@postgresql.org
Subject: [OT] Flushing Postgres Function Cache
Date: Thu, 17 May 2007 09:36:22 +0100 (BST)
Message-ID: <20070517092853.R69332@joshua.dreamthought.com> (raw)

Greetings,

In the face of shabby google results, I hoped that someone hear might know 
something about the postgres function cache.  We have a server which 
reports an error of the form "cache lookup failed for function <oid>."

Initially, I'd hoped to resolve this without a restart (which didn't do 
the trick either), and had been searching for some way to clear postgres' 
internal function cache - I think it stores plans/hints/compiled-version 
relating to stored proc's?

I tried to select the reported oid out of pg_proc, which resulted in an 
empty set.

I then went on to explicitly drop the function and recreate it.  This was 
interspersed with numerous postgres restarts and dropping of all client 
connections.  In spite of this I still get the same error from our client 
which still reports the same OID; which doesn't exist in pg_proc.

In any case, I can't seem to find any documentation which tells me how 
to clear this cache.

Versions:

pg: postgresql v 8.0.1-r4
os: Gentoo Linux/Kernel 2.6.12.5 #1

Any help would be of value?

Cheers,

Raf






view thread (2+ messages)  latest in thread

Message-ID: <20070517092853.R69332@joshua.dreamthought.com>
Permalink:  ../20070517092853.R69332@joshua.dreamthought.com/
Also on:    postgresql.org/message-id/20070517092853.R69332@joshua.dreamthought.com

 · 

reply

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: rafiq@joshua.dreamthought.com
  Subject: Re: [OT] Flushing Postgres Function Cache
  In-Reply-To: <20070517092853.R69332@joshua.dreamthought.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