From: Y Sidhu <ysidhu@gmail.com>
To: pgsql-performance@postgresql.org
Subject: max_fsm_pages, shared_buffers and checkpoint_segments
Date: Wed, 23 May 2007 09:22:22 -0700
Message-ID: <b09064f30705230922j35a69ea4ie5ff38d63d199065@mail.gmail.com> (raw)
I am a newbie, as you all know, but I am still embarassed asking this
question. I started my tuning career by changing shared_buffers. Soon I
discovered that I was hitting up against the available RAM on the system.
So, I brought the number down. Then I discovered max_fsm_pages. I could take
that up quite high and found out that it is a 'disk' thing. Then I started
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
shared_buffers or max_fsm_pages back down, the daemon starts and all is
normal. This happens on a 1 GB RAM machine and a 4 GB RAM machine.
Anyone know what I am doing wrong?
System: FreeBSD 6.1, Postgresql 8.09, 2 GB RAM
--
Yudhvir Singh Sidhu
408 375 3134 cell
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: ysidhu@gmail.com
Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments
In-Reply-To: <b09064f30705230922j35a69ea4ie5ff38d63d199065@mail.gmail.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