postgresql.conf suggestions?
От | Kobby Dapaah |
---|---|
Тема | postgresql.conf suggestions? |
Дата | |
Msg-id | 4A142E3D.3070003@gmail.com обсуждение исходный текст |
Ответы |
Re: postgresql.conf suggestions?
Re: postgresql.conf suggestions? |
Список | pgsql-performance |
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
В списке pgsql-performance по дате отправления: