RAID10 stripe size and PostgreSQL performance

Artem Naluzhnyy <[email protected]> Mon, 8 Jul 2013 15:40:19 +0300

Newsgroups	gmane.os.freebsd.devel.file-systems,gmane.os.freebsd.devel.database
Message-ID	<CAEGTrdKZetiwczu=39433KtX3Px7vgsJxzFBB-_AtAgsKoYkdw@mail.gmail.com>

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
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-fs
To unsubscribe, send any mail to "[email protected]"