Re: Autovacuum / full vacuum

From: hubert depesz lubaczewski <depesz(at)gmail(dot)com>
To: Michael Riess <mlriess(at)gmx(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum / full vacuum
Date: 2006-01-17 15:10:34
Message-ID: 9e4684ce0601170710o61e2af02o1b53890cfe972812@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 1/17/06, Michael Riess <mlriess(at)gmx(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-01-17 15:13:41 Re: Autovacuum / full vacuum
Previous Message Andrew Sullivan 2006-01-17 15:09:48 Re: Autovacuum / full vacuum