From: Rick Schumeyer <rschumeyer@ieee.org>
To: pgsql-performance@postgresql.org
Subject: Configuration settings (shared_buffers, etc) in Linux: puzzled
Date: Thu, 24 Jan 2008 13:00:24 -0500
Message-ID: <4798D238.7070002@ieee.org> (raw)
On a linux box (Linux db1 2.6.18.8-md #1 SMP Wed May 23 17:21:37 EDT
2007 i686 GNU/Linux)
I edited postgresql.conf and changed:
shared_buffers = 5000 work_mem = 16384
max_stack_depth = 4096
and then restarted postgres. The puzzling part is that postgres
actually started. When I have done this on other boxes, I had to edit
kernel settings to allow for more shared memory.
The kernel settings are currently:
shmmax: 33554432
shmall: 2097152
I would have expected to need to increase these before postgres would run.
I have a nagging suspicion that something isn't right. Like it's not
actually reading the conf file, or I might have a problem on reboot.
I'm not sure if I'm worrying about nothing, or if something weird is
going on.
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: rschumeyer@ieee.org
Subject: Re: Configuration settings (shared_buffers, etc) in Linux: puzzled
In-Reply-To: <4798D238.7070002@ieee.org>
* 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