I have just configured our disks to raid10 from raid5. The raid 10 is now 6 drives giving us 750G use by OS and postgres.
What is the preferred setup for postgres concerning cache settings on the controller and disks and the preferred block size allocated for the disks when postgres uses block size 8192?
Disk setting Write Cache : Disabled (write-through)
Postgresql.conf fsync = on # turns forced synchronization on or off #synchronous_commit = on # immediate fsync at commit wal_sync_method = fsync # the default is the first option
Logical drive number 1 Logical drive name : RAID10 RAID level : 10 Status of logical drive : Okay Size : 858000 MB Read-cache mode : Enabled Write-cache mode : Enabled (write-back) Write-cache setting : Enabled (write-back) when protected by battery Partitioned : Yes Number of segments : 6 Stripe-unit size : 256 KB Stripe order (Channel,Device) : 0,0 0,1 0,2 0,3 0,4 0,5 Defunct segments : No Defunct stripes : No
Device #0 Device is a Hard drive State : Online Supported : Yes Transfer Speed : SAS 3.0 Gb/s Reported Channel,Device : 0,0 Vendor : IBM-ESXS Model : ST3300655SS Firmware : BA26 World-wide name : 5000C5000A42EFAC Size : 286102 MB Write Cache : Disabled (write-through) FRU : None PFA