Lonni J Friedman <netllama(at)gmail(dot)com> writes:
> I've got a pesky J2EE based app that is using PostgreSQL-7.4.x on the
> backend. Lately i've been getting a disturbing large number of
> PostgreSQL out of memory exceptions on the J2EE side when running
> queries that have some huge joins in them.
Such an error on the client side would indicate that the query retrieved
more rows than the client app had memory for. Perhaps your problem is
incorrectly-constrained joins that are returning way more rows than
you expect?
regards, tom lane