Naz Gassiep <[EMAIL PROTECTED]> 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° ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/