Re: ERROR: Out of memory - when connecting to database

On Mon, Nov 08, 2010 at 07:19:43PM +0100, Jakub Ouhrabka wrote:
> Hi,
>
> we have several instances of following error in server log:
>
> 2010-11-08 18:44:18 CET 5177 1 @ ERROR: out of memory
> 2010-11-08 18:44:18 CET 5177 2 @ DETAIL: Failed on request of size 16384.
>
> It's always the first log message from the backend. We're trying to
> trace it down. Whether it's always connection attempt to the same
> database or not - I don't know at the moment.
>
> Sometimes the error message is preceded by memory stats which are
> below in the email.
>
> Other relevant data:
> Linux, PostgreSQL 8.2.10
> RAM 28GB
>
> max_connections = 2048
>
> shared_buffers = 2048MB
>
> temp_buffers = 32MB
> max_prepared_transactions = 0
>
> max_fsm_pages = 10000000
> max_fsm_relations = 100000

is it 32bit or 64bit machine?

what's the work_mem?

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007