PG Bug reporting form <noreply@postgresql.org> writes:
> Prepared Statements take too much memory.
I'm not really sure what you expect us to do about this. If you
PREPARE a bunch of statements and never DEALLOCATE them, then yes
they're going to consume memory; maybe a lot of memory if the
plans are complex.
The only thing we could do to reduce the memory consumption is to
throw away the plans, which kind of defeats the purpose of a
prepared statement, wouldn't you say? And even holding onto enough
information to re-create the plan later would consume some amount
of memory, so you will still have a problem if you keep making
prepared statements and never release them.
regards, tom lane