Lonni J Friedman <netllama@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
