> this is my config > > checkpoint_segments = 96 > effective_cache_size = 128000 > shared_buffers = 430000 > max_fsm_pages = 208000 > max_fsm_relations = 10000 > > max_connections = 1000 > > autovacuum = off # enable autovacuum subprocess? > > fsync = on # turns forced synchronization on > or off > #full_page_writes = on # recover from partial page writes > wal_sync_method = fdatasync > wal_buffers = 256 > > commit_delay = 5 > #commit_siblings = 5 # range 1-1000
Now that you hopefully understand more about the server i am building, does anybody got any suggestions on improvements of the config? I could certainly reduce the max_connections to 1/10. but are there other configurations that could either be reduced or increased or even set to a non default value? regards thomas ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
