I will definitely look into this. I suspect I need to tune my kernel settings first though... culley On Sat, Aug 8, 2009 at 8:40 PM, Robert Haas<robertmhaas@xxxxxxxxx> wrote: > On Fri, Aug 7, 2009 at 5:24 PM, Culley Harrelson<harrelson@xxxxxxxxx> wrote: >> Hi Everyone, >> >> I manage a freeBSD server that is dedicated to postgresql. The >> machine has 4 gigs of ram and there is a single database powering a >> web application that is hosted on a neighboring machine. The web >> application is mostly reading the database but there are considerable >> writes and I don't want to tune the machine exclusively for writes. I >> realize more information would be needed to optimally tune the machine >> but I am seeking advice on making some sane kernel settings for a >> general purpose database on a dedicated system. Currently I have: >> >> $ cat /etc/sysctl.conf >> >> kern.ipc.shmmax=268435456 >> kern.ipc.shmall=65536 >> >> and >> >> $ cat /boot/loader.conf >> kern.ipc.semmni="256" >> kern.ipc.semmns="512" >> kern.ipc.semmnu="256" >> >> In postgresql.conf I have: >> >> max_connections = 180 >> shared_buffers = 28MB >> >> I would like to increase this to 256 connections and make sure the >> kernel settings are giving postgresql enough breathing room without. >> I suspect my settings are conservative and since the machine is >> dedicated to postgresql I would like to give it more resources if they >> could be used. Any suggestions? > > This might be worth a look, for starters. > > http://pgfoundry.org/projects/pgtune/ > > ...Robert > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
