Hello All, I have a brand new machine to tune: x3750 M4, 4xE5-4640v2 2.2GHz; 512GBRAM (32x16GB), 4x300GB SAS + SSD (Easy Tier) in RAID 10 What's particularly important now is to choose optimal configuration for write operations. We have discussion about checkpoint_segments and checkpoint_timeout parameters. Test, which was based on pg_replay, has shown that the biggest amount of data is written when checkpoint_segments are set to 10 000 and checkpoint_timeout to 30 min, but I'm worrying about amount of time needed for crash recovery. On the other hand it's mighty machine :) and I don't wanna go back with 30 segments. I'd appreciate any helpful remark on that. The rest of parameters from the test: shared_buffers=2GB temp_buffers=128MB max_files_per_process=500 work_mem=256MB maintenance_work_mem=128MB effective_io_concurrency=50 synchronous_commit=local wal_buffers=512kB wal_writer_delay=1ms commit_delay=100 commit_siblings=1000 random_page_cost=1.0 cpu_tuple_cost=2.0 effective_cache_size=500GB geqo_threshold=20 geqo_effort=10 geqo_selection_bias=2.0 join_collapse_limit=16 -- View this message in context: http://postgresql.1045698.n5.nabble.com/Optimal-checkpoint-setting-tp5822359.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
