Thread: max_fsm_pages

I just did a vacuum analyze and I got a message I've never seen before:

conwatchlive=# vacuum analyze;
NOTICE:  number of page slots needed (27056) exceeds max_fsm_pages (20000)
HINT:  Consider increasing the configuration parameter "max_fsm_pages"
to a value over 27056.
VACUUM
conwatchlive=#

What does this mean? I assume it has nothing to do with the Flying
Spaghetti Monster.

More generally, I am a novice at administering a PostgreSQL database, is
there a list of tips somewhere that I can read to improve performance?

Naz Gassiep <naz@mira.net> schrieb:

> NOTICE:  number of page slots needed (27056) exceeds max_fsm_pages (20000)
> HINT:  Consider increasing the configuration parameter "max_fsm_pages" to a
> value over 27056.
> VACUUM
> conwatchlive=#
>
> What does this mean? I assume it has nothing to do with the Flying

Read again ;-) You should increase 'max_fsm_pages' ;-)


> More generally, I am a novice at administering a PostgreSQL database, is
> there a list of tips somewhere that I can read to improve performance?

Yes, for instance, read this:
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°