Ben Chobot <bench(at)silentmedia(dot)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 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?
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