On Apr 23, 2010, at 6:00 PM, Tom Lane wrote: > Ben Chobot <bench@xxxxxxxxxxxxxxx> 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 Heh, woops, sorry, it's 8.4, and yes, a simple table analyze was all I needed. Thanks! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
