Re: max_fsm_pages, shared_buffers and checkpoint_segments

From: PFC <lists(at)peufeu(dot)com>
To: "Y Sidhu" <ysidhu(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments
Date: 2007-05-23 17:56:11
Message-ID: op.tssj3xc0cigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> When I bring shared_buffers or max_fsm_pages back down, the daemon
> starts and all is
> normal.

Linux has a system setting for the maximum number of shared memory that a
process can allocate. When Postgres wants more, Linux says "No."
Look in the docs for the setting (sysctl whatsisname).
VACUUM VERBOSE will tell you if you need to put more max_fsm_pages or not.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Susan Russo 2007-05-23 18:18:41 Re: does VACUUM ANALYZE complete with this error?
Previous Message Ben 2007-05-23 17:00:22 Re: max_fsm_pages, shared_buffers and checkpoint_segments