Re: Backend sent D message without prior T

Antonis Antoniou <a(dot)antoniou(at)albourne(dot)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