Re: Troubleshooting cored dumps

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Troubleshooting cored dumps
Дата
Msg-id 20020419151426.W76862-100000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Re: Troubleshooting cored dumps  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Alex Krohn
Дата:
Сообщение: unable to repair table: missing chunk number
Следующее
От: jtp
Дата:
Сообщение: general design question