Sunday, October 12, 2008

change zfs deault blocksize for postgresql

(09:25:21 PM) e^ipi: azathoth99: read the ZFS tuning guide for postgres too... if your database is sitting on ZFS you should change the default block size
(09:25:28 PM) Triskelios: azathoth99: http://www.sun.com/servers/coolthreads/t2000/benchmarks.jsp for example, google has plenty of (probably less biased) sources
(09:25:35 PM) e^ipi: should be: 8k, is: 128k
(09:25:53 PM) azathoth99: woa
(09:26:01 PM) e^ipi: IIRC 32k on mysql
(09:26:34 PM) e^ipi: the default is a good default, it's just better to tweak it for the workload

No comments: