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

Re: cached plans in plpgsql

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Kuba Ouhrabka" <kuba(at)comgate(dot)cz>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: cached plans in plpgsql
Date: 2005-10-20 15:03:58
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD640@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-performance
Kuba wrote:

> is there an easy way to flush all cached query plans in pl/pgsql
> functions? I've long running sessions where data are changing and the
> plans become inaccurate after a while. I can imagine something like
> recreating all pl/pgsql functions. I can recreate them from sql source
> files but I'd prefer recreating them inside the database without
> accessing files outside. I can think only of one way - reconstructing
> function source code from pg_proc and EXECUTEing it. But it's not the
> cleanest solution (there isn't saved the actual source code anywhere
so
> there could be problems with quoting etc.). Can you see any other
> possibility? How do you solve this problem? [And yes, I don't want to
> re-connect...]

Start here:
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00690.php

Merlin

Responses

pgsql-performance by date

Next:From: Kuba OuhrabkaDate: 2005-10-20 16:25:12
Subject: Re: cached plans in plpgsql
Previous:From: Tom LaneDate: 2005-10-20 14:15:19
Subject: Re: [HACKERS] tuning seqscan costs

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