From: Peter Schuller <peter.schuller@infidyne.com>
To: Y Sidhu <ysidhu@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments
Date: Wed, 23 May 2007 22:40:31 +0200
Message-ID: <4654A6BF.4040501@infidyne.com> (raw)
In-Reply-To: <b09064f30705230922j35a69ea4ie5ff38d63d199065@mail.gmail.com>
References: <b09064f30705230922j35a69ea4ie5ff38d63d199065@mail.gmail.com>
> increasing checkpoint_segments,which is also a disk thing. However, setting
> it to 25, and then increasing any of the other 2 variables, the postgresql
> daemon stops working. meaning it does not start upon reboot. When I bring
Sounds like you need to increase your shared memory limits.
Unfortunately this will require a reboot on FreeBSD :(
See:
http://www.postgresql.org/docs/8.2/static/kernel-resources.html
Last time I checked PostgreSQL should be complaining about the shared
memory on startup rather than silently fail though. Check your logs
perhaps. Though I believe the RC script will cause the message to be
printed interactively at the console too, if you run it. (Assuming you
are using it installed from ports).
--
/ Peter Schuller
PGP userID: 0xE9758B7D or 'Peter Schuller <peter.schuller@infidyne.com>'
Key retrieval: Send an E-Mail to getpgpkey@scode.org
E-Mail: peter.schuller@infidyne.com Web: http://www.scode.orgAttachments:
signature.asc (application/pgp-signature, 249B) download
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-performance@postgresql.org
Cc: peter.schuller@infidyne.com, ysidhu@gmail.com
Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments
In-Reply-To: <4654A6BF.4040501@infidyne.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