Antonis Antoniou <[EMAIL PROTECTED]> 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
