Re: Troubleshooting cored dumps
Francisco Reyes <lists@natserv.com>
From: Francisco Reyes <lists@natserv.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql General List <pgsql-general@postgresql.org>
Date: 2002-04-19T19:17:34Z
Lists: pgsql-general
On Fri, 19 Apr 2002, Tom Lane wrote: > I'll save you the trouble: I'll bet that psql ran out of memory for a > huge result set. libpq is not real robust about coping with that :-(. Thanks Tom. That hint was enough. I looked at the query... real hard. :-) Found that I was missing a join condition so my return set would have been gigantic (cartisian product of tables with close to 1 Million records)