Re: Autovacuum / full vacuum
От
hubert depesz lubaczewski
Тема
Re: Autovacuum / full vacuum
Дата
Msg-id
9e4684ce0601170710o61e2af02o1b53890cfe972812@mail.gmail.com
Ответ на
Re: Autovacuum / full vacuum (Michael Riess)
Список
Дерево обсуждения
Re: Autovacuum / full vacuum Christopher Browne <cbbrowne@acm.org>
Re: Autovacuum / full vacuum Michael Riess <mlriess@gmx.de>
Re: Autovacuum / full vacuum Michael Stone <mstone+postgres@mathom.us>
Re: Autovacuum / full vacuum Andrew Sullivan <ajs@crankycanuck.ca>
Re: Autovacuum / full vacuum Scott Marlowe <smarlowe@g2switchworks.com>
Re: Autovacuum / full vacuum Andrew Sullivan <ajs@crankycanuck.ca>
Re: Autovacuum / full vacuum Scott Marlowe <smarlowe@g2switchworks.com>
Re: Autovacuum / full vacuum "Jim C. Nasby" <jnasby@pervasive.com>
Re: Autovacuum / full vacuum Michael Riess <mlriess@gmx.de>
Re: Autovacuum / full vacuum "Jim C. Nasby" <jnasby@pervasive.com>
Re: Autovacuum / full vacuum hubert depesz lubaczewski <depesz@gmail.com>
On 1/17/06, Michael Riess <mlriess@gmx.de> wrote:
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
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 по дате отправления
