Date: Mon, 8 Jul 2013 15:40:19 +0300 From: Artem Naluzhnyy <artem.naluzhnyy@gmail.com> To: freebsd-database@freebsd.org, freebsd-fs@freebsd.org Subject: RAID10 stripe size and PostgreSQL performance Message-ID: <CAEGTrdKZetiwczu=39433KtX3Px7vgsJxzFBB-_AtAgsKoYkdw@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
Hi, I'm benchmarking PostgreSQL using different RAID10 stripe size values for a new server. Tried bonnie++ and pgbench on two stripe size configurations: * 32 KB (a half of current UFS bsize) - 254 pgbench tps * 1 MB (max supported by the RAID controller) - 626 pgbench tps See OS/hardware configuration, benchmark methodology and raw results here - http://pastebin.com/F8uZEZdm Is this expected behavior with more than twice higher pgbench tps on 1MB stripe size? Are there any RAID stripe size recommendations for better PostgreSQL performance? (I can not change the FS type, standard PG block size etc. - they are locked by vendor in this commercial FreeBSD distribution) -- Artem Naluzhnyy
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAEGTrdKZetiwczu=39433KtX3Px7vgsJxzFBB-_AtAgsKoYkdw>