Re: Backend sent D message without prior T

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