I'm having performance issues on postgresql 8.2 and think I've concluded that the problem is that postgresql cannot optimize queries by using constraint exclusion or partial indexes when prepared statements are used via hibernate.

Is there any way to disable prepared statements at the session or session factory level? I could not find any answers in the forum or documentation.

I guess it could be done by hand creating sql statements but it seems like this would be a real pain and fragile.

thanks