pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: ngaleyev@wavelengthmail.com
To: pgsql-admin@postgresql.org
Subject: Re: hot restart of posgtresql
Date: Wed, 4 Jul 2007 02:38:23 -0400 (EDT)
Message-ID: <1089.209.168.137.101.1183531103.squirrel@wavelengthmail.com> (raw)

thanks for replies everyone
platform is Debian 2.6 btw

Heres how i got temp fix (i dont have much background in postgresql, so dont
kick me hard):
few months ago old admin upgraded to 6GB of ram and increased shared_buffers
in posgresql.conf from  16384 to 393216 (3GB)
He also modifed sysctl to look like this:
-----
kernel.shmmax=4294967296
kernel.shmall=536870912
-----
I looked in top command, and dmesg, both indicate 6GB of ram. So I started
gradually increase "sysctl -w kernel.shmmax=xxx"
during that i was checking out  /proc/sys/kernel/shmmax
it was keeping up with corresponding values until i reached that number -
4294967296, it was showing "0" instead. so i lowered it to 4200000000,
about highest number that would not null that /proc value.
Still wouldnt start :( but with different error now, didnt save it
After that i decreased shared_buffers back to 16384, and it worked. Didnt
mess with it anymore for right now, don't want to experiment on live server.
Old admin is not around anymore, so I sort of inherited responsibility for
the server, but I don't know much about postgresql yet.

So, whats the optimum values for this amount of memory as far as SHMALL, MAX
and shared_buffers?
Database size is about 115GB, daily traffic is about 800MB.

Thanks alot
-Nik





view thread (5+ messages)

Message-ID: <1089.209.168.137.101.1183531103.squirrel@wavelengthmail.com>
Permalink:  ../1089.209.168.137.101.1183531103.squirrel@wavelengthmail.com/
Also on:    postgresql.org/message-id/1089.209.168.137.101.1183531103.squirrel@wavelengthmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ngaleyev@wavelengthmail.com
  Subject: Re: hot restart of posgtresql
  In-Reply-To: <1089.209.168.137.101.1183531103.squirrel@wavelengthmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox