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

 > is it 32bit or 64bit machine?

64bit

 > what's the work_mem?

64MB

Kuba

Dne 8.11.2010 19:52, hubert depesz lubaczewski napsal(a):
> 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
>