Re: pulling hair out trying to force replan

["Adam Rich" <adam(dot)r(at)sbcglobal(dot)net>]

> I've got some pretty big tables with partial indexes 
> on very specific values. It seems as though no matter 
> what I try to force a replan it won't plan to use the 
> partial indexes because it seems to be caching a plan 
> valid for all potential parameters. I'm using hibernate 
> which uses prepared statements over jdbc. I've tried 
> setting prepareThreshold=0 to no avail. 

> Any suggestions would be most appreciated, I've been 
> trying to solve this for a week now :(

Not sure how much this will help you, but you can query 
The pg_prepared_statements view to find the prepared 
statement that's causing your headaches (S_127/C_128
in your example) and feed it to DEALLOCATE.


http://www.postgresql.org/docs/8.2/interactive/view-pg-prepared-statemen
ts.html

http://www.postgresql.org/docs/8.2/interactive/sql-deallocate.html