I will be getting a SAN with a battery backed write cache for a new Postgres data warehouse and am not sure what settings to apply to make proper use of it. If the cache is enabled in the SAN is that enough or do I need to set wal_sync_method, synchronous_commit or others?
The warehouse will be handling 5-10 million row inserts a day once the current data sources are turned on. This will most likely grow in the future.
We will be using Postrges 9.3 and most likely Centos 6.4.
Thanks in advance.