Re: Autovacuum / full vacuum - Mailing list pgsql-performance

From hubert depesz lubaczewski
Subject Re: Autovacuum / full vacuum
Date
Msg-id 9e4684ce0601170710o61e2af02o1b53890cfe972812@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum / full vacuum  (Michael Riess <mlriess@gmx.de>)
List 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

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Autovacuum / full vacuum
Next
From: Tom Lane
Date:
Subject: Re: Autovacuum / full vacuum