Re: Cannot allocate memory for output buffer

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Erickson <redlamb(at)redlamb(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot allocate memory for output buffer
Date: 2009-11-27 23:12:29
Message-ID: 21941.1259363549@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Erickson <redlamb(at)redlamb(dot)net> writes:
> Thanks. Out of curiosity, if memory exhaustion was the problem, any idea
> why the task manager would show that I'm only using 1.2GB of the 3GB of
> memory?

Well, it would've failed to allocate the next copy of the string that it
needed ... and I think also we try to keep the output buffer size at a
power of 2, so it might have been asking for 2GB for the output buffer.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Lanczos 2009-11-28 00:11:38 incorrect restore from pg_dumpall
Previous Message Tom Lane 2009-11-27 23:10:31 Re: empty string causes planner to avoid index. Makes me sad.