Re: "out of memory" error

hubert depesz lubaczewski wrote:
> On Wed, Aug 22, 2007 at 07:07:20PM +0200, Christian Schröder wrote:
>
>> These are the current settings from the server configuration:
>>    shared_buffers = 3GB
>>
>
> this is *way* to much. i would suggest lowering it to 1gig *at most*.
>
Ok, I can do this, but why can more memory be harmful?
>>    max memory size         (kbytes, -m) 3441565
>>
>
> this looks like too close to shared_buffers. again - lower it.
>
What happens if I set shared_buffers higher than the ulimit?
>> The machine is a linux box with 4 GB memory running PostgreSQL 8.2.4.
>>
>
> is it by any chance i386 architecture?
>
Linux db2 2.6.18.8-0.3-default #1 SMP Tue Apr 17 08:42:35 UTC 2007
x86_64 x86_64 x86_64 GNU/Linux

Intel(R) Xeon(R) CPU 5130  @ 2.00GHz with 4 logical processors (2 physical)

vm.overcommit_memory = 2 # No memory overcommit.

Regards,
    Christian

--
Deriva GmbH                         Tel.: +49 551 489500-42
Financial IT and Consulting         Fax:  +49 551 489500-91
Hans-Böckler-Straße 2                  http://www.deriva.de
D-37079 Göttingen

Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer