Re: Config Check

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: Bryan <bvest(at)rhondasworld(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Config Check
Date: 2004-12-06 15:18:00
Message-ID: opsild4ax9cq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

According to these lines you should set max_fsm_pages to at the very
least 5306160
You have a humongous amount of RAM, you could set it to 10000000

> INFO: free space map: 79 relations, 1948399 pages stored; 5306160 total
> pages needed
> DETAIL: Allocated FSM size: 500 relations + 2000000 pages = 11769 kB
> shared memory.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pallav Kalva 2004-12-06 15:28:23 Poor Query
Previous Message Bryan 2004-12-06 14:43:42 Config Check