Re: max_fsm_pages

Naz Gassiep <naz(at)mira(dot)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°