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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
