Search Postgresql Archives

Re: out of memory error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Craig Ringer wrote:
On 3/07/2011 6:00 PM, Geoffrey Myers wrote:

out of memory for query result

How is this possible?

Resource limits?


Could this message be generated because of shared memory issues?

The odd thing is the error was generated by a user process, but there is no reference to the error in the database log file.


Do you have a ulimit in place that applies to postgresql? You can check by examining the resource limits of a running postgresql backend as shown in /proc/$PG_PID where $PG_PID is the process ID of the backend of interest.

Check your work_mem in postgresql.conf, too.

work_mem is commented out on both machines, so I suspect that it is then using the default value? What would be the default value?


--
Craig Ringer



--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux