Soumya Prasad Ukil <soumyo...@yahoo.co.in> writes: > I have been using postgres prepare statement feature through JDBC. I could > see the same prepare statement multiple times, parsing is not happening in > postgres backend, which is expected. However I do the same in psql command > line, that does not happen. It goes to parsing every time I execute
Perhaps "set plan_cache_mode = force_generic_plan" would help you. Bear in mind that this is likely to be a net loss overall. regards, tom lane