Naz Gassiep <naz@xxxxxxxx> 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°
