Skip site navigation (1) Skip section navigation (2)

[OT] Flushing Postgres Function Cache

From: Raf <rafiq(at)joshua(dot)dreamthought(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: [OT] Flushing Postgres Function Cache
Date: 2007-05-17 08:36:22
Message-ID: 20070517092853.R69332@joshua.dreamthought.com (view raw or flat)
Thread:
Lists: pgsql-admin
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




Responses

pgsql-admin by date

Next:From: Sorin N. CiolofanDate: 2007-05-17 09:14:17
Subject: Re: increasing of the shared memory does not solve theproblem of "OUT of shared memory"
Previous:From: Peter EisentrautDate: 2007-05-17 07:33:40
Subject: Re: pg_dump not enough space to create a backup FreeBSD 6.1?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group