how to invalidate a stored procedure's plan?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: how to invalidate a stored procedure's plan?
Date: 2010-04-24 00:52:06
Message-ID: 083A92DD-54D2-429F-A97B-F3CE44EF4468@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 index to become expensive, and so the procedure has cached a plan that uses a full table scan. I've since fixed the index bloat, but the procedure still seems to be doing full table scans. Is there a non-disruptive way to invalidate the cached plan for that procedure globally?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-04-24 01:00:01 Re: how to invalidate a stored procedure's plan?
Previous Message Justin Pasher 2010-04-23 22:46:16 Re: Postgres stats collector showing high disk I/O