From: | Jakub Ouhrabka <kuba(at)comgate(dot)cz> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: Out of memory - when connecting to database |
Date: | 2010-11-08 19:04:32 |
Message-ID: | 4CD849C0.2000906@comgate.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jakub Ouhrabka | 2010-11-08 19:05:23 | Re: ERROR: Out of memory - when connecting to database |
Previous Message | dan.m.harris | 2010-11-08 19:01:49 | Failed archive_command copy - number of attempts configurable? |