Postgres Pro
Downloads
Home   >   mailing lists

Re: how to invalidate a stored procedure's plan? - Mailing list pgsql-general

From Tom Lane
Subject Re: how to invalidate a stored procedure's plan?
Date
Msg-id 21813.1272070801@sss.pgh.pa.us
Whole thread Raw
In response to how to invalidate a stored procedure's plan?  (Ben Chobot <bench@silentmedia.com>)
Responses Re: how to invalidate a stored procedure's plan?  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
Tree view 
Ben Chobot <bench@silentmedia.com> writes:
> I have a procedure that queries a table. This should be fast because of an index, but some index bloat has caused the
indexto become expensive, and so the procedure has cached a plan that uses a full table scan. I've since fixed the
indexbloat, but the procedure still seems to be doing full table scans. Is there a non-disruptive way to invalidate the
cachedplan for that procedure globally? 

What PG version?  In 8.3 and up an ANALYZE on any of the tables
mentioned in the problem query should suffice.

            regards, tom lane

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: how to invalidate a stored procedure's plan?
Next
From: Ben Chobot
Date:
Subject: Re: how to invalidate a stored procedure's plan?