Re: Backend sent D message without prior T

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Backend sent D message without prior T
Дата
Msg-id 15254.982175794@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Backend sent D message without prior T  (Antonis Antoniou <a.antoniou@albourne.com>)
Список pgsql-general
Antonis Antoniou <a.antoniou@albourne.com> writes:
> Tom Lane wrote:
>> IIRC, this is a fairly common symptom of the frontend app running out
>> of memory --- libpq loses sync with what the backend is sending, and
>> it doesn't handle that very gracefully.

> This is strange because the machine has 1GB of memory.  Using the same
> database on PostgreSQL 7.0.2  and on a machine that has 500MB of memory
> the above query works fine.

But what do you have the per-process memory limit set to on this
machine?  (ulimit, kernel MAXDSIZ parameter, or swap space limits might
be preventing your frontend from using all available memory.)

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Louis-David Mitterrand
Дата:
Сообщение: using tables as types in other tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tmp_pg_shadow