I just upgraded from a 2xIntel Xeon-Harpertown 5450-Quadcore,16 GB,Redhat EL 5.1-64 To 2xIntel Xeon-Nehalem 5570-Quadcore,36GB,Redhat EL 5.3-64 Any advice on how I'll get the best of this server? This is what I currently have: max_connections = 100 shared_buffers = 2048MB maintenance_work_mem = 128MB max_fsm_pages = 1000000 bgwriter_delay = 10ms bgwriter_lru_maxpages = 0 wal_sync_method = open_sync wal_buffers = 2MB checkpoint_segments = 64 checkpoint_warning = 270s archive_mode = on effective_cache_size = 5400MB default_statistics_target = 500 logging_collector = on log_rotation_size = 100MB log_min_duration_statement = 1000 log_connections = off log_disconnections = off log_duration = off log_line_prefix = '%t' track_counts = on autovacuum = on statement_timeout = 5min -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
