Re: [GENERAL] pulling hair out trying to force replan

2007-02-25 Thread Adam Rich
> 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

[GENERAL] pulling hair out trying to force replan

2007-02-25 Thread Gene
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 stateme