Re: Troubleshooting cored dumps - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Troubleshooting cored dumps
Date
Msg-id 20020419151426.W76862-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Troubleshooting cored dumps  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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)


pgsql-general by date:

Previous
From: Alex Krohn
Date:
Subject: unable to repair table: missing chunk number
Next
From: jtp
Date:
Subject: general design question