Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 7AEF49FBC2D for ; Wed, 23 May 2007 17:40:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 40978-04 for ; Wed, 23 May 2007 17:40:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mxfep04.bredband.com (mxfep04.bredband.com [195.54.107.79]) by postgresql.org (Postfix) with ESMTP id 08F099FA5BF for ; Wed, 23 May 2007 17:40:45 -0300 (ADT) Received: from ironport.bredband.com ([195.54.107.82] [195.54.107.82]) by mxfep04.bredband.com with ESMTP id <20070523204043.IARP14638.mxfep04.bredband.com@ironport.bredband.com> for ; Wed, 23 May 2007 22:40:43 +0200 Received: from c-5416e555.03-51-73746f3.cust.bredbandsbolaget.se (HELO scode.mine.nu) ([85.229.22.84]) by ironport.bredband.com with ESMTP; 23 May 2007 22:40:43 +0200 Received: from scode.mine.nu (localhost [127.0.0.1]) by scode.mine.nu (Postfix) with ESMTP id E2B85A160; Wed, 23 May 2007 22:40:40 +0200 (CEST) Message-ID: <4654A6BF.4040501@infidyne.com> Date: Wed, 23 May 2007 22:40:31 +0200 From: Peter Schuller User-Agent: Thunderbird 2.0.0.0 (X11/20070501) MIME-Version: 1.0 To: Y Sidhu CC: pgsql-performance@postgresql.org Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments References: In-Reply-To: X-Enigmail-Version: 0.95.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enigE00F8EE4FD839C22F435CDB2" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/469 X-Sequence-Number: 24859 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigE00F8EE4FD839C22F435CDB2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable > increasing checkpoint_segments,which is also a disk thing. However, set= ting > it to 25, and then increasing any of the other 2 variables, the postgre= sql > daemon stops working. meaning it does not start upon reboot. When I bri= ng 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). --=20 / Peter Schuller PGP userID: 0xE9758B7D or 'Peter Schuller ' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org --------------enigE00F8EE4FD839C22F435CDB2 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGVKbIDNor2+l1i30RCPPjAJ9LwcsT+PnFHW3zwWD6C8HFvCPLCQCgofDd dlXxha9H0uJreDV0fEnlXVI= =L25V -----END PGP SIGNATURE----- --------------enigE00F8EE4FD839C22F435CDB2--