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°