Horton
Menu

Re: Autovacuum / full vacuum

hubert depesz lubaczewski <depesz@gmail.com>

View thread
From: hubert depesz lubaczewski <depesz@gmail.com>
To: Michael Riess <mlriess@gmx.de>
Cc: pgsql-performance@postgresql.org
Date: 2006-01-17T15:10:34Z
Lists: pgsql-performance 
On 1/17/06, Michael Riess <mlriess@gmx.de> wrote:
>
> about the FSM: You say that increasing the FSM is fairly cheap - how
> should I know that?
>

comment from original postgresql.conf file seems pretty obvious:
#max_fsm_pages = 20000          # min max_fsm_relations*16, 6 bytes each
#max_fsm_relations = 1000       # min 100, ~70 bytes each

basically setting max_fsm_pages to 1000000 consumes 6 megabytes. and i
definitelly doubt you will ever hit that high.

depesz