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

From Ben Chobot
Subject how to invalidate a stored procedure's plan?
Date
Msg-id 083A92DD-54D2-429F-A97B-F3CE44EF4468@silentmedia.com
Whole thread Raw
Responses Re: how to invalidate a stored procedure's plan?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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? 

pgsql-general by date:

Previous
From: Justin Pasher
Date:
Subject: Re: Postgres stats collector showing high disk I/O
Next
From: Tom Lane
Date:
Subject: Re: how to invalidate a stored procedure's plan?