Date: Mon, 08 Jul 2013 17:16:45 +0200 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-fs@freebsd.org Cc: freebsd-database@freebsd.org Subject: Re: RAID10 stripe size and PostgreSQL performance Message-ID: <krel4o$q96$1@ger.gmane.org> In-Reply-To: <CAEGTrdKZetiwczu=39433KtX3Px7vgsJxzFBB-_AtAgsKoYkdw@mail.gmail.com> References: <CAEGTrdKZetiwczu=39433KtX3Px7vgsJxzFBB-_AtAgsKoYkdw@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156) ------enig2UBCEUFKHBCWAHTMQXKDM Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On 08/07/2013 14:40, Artem Naluzhnyy wrote: > Hi, >=20 > I'm benchmarking PostgreSQL using different RAID10 stripe size values > for a new server. Tried bonnie++ and pgbench on two stripe size > configurations: >=20 > * 32 KB (a half of current UFS bsize) - 254 pgbench tps > * 1 MB (max supported by the RAID controller) - 626 pgbench tps >=20 > See OS/hardware configuration, benchmark methodology and raw results > here - http://pastebin.com/F8uZEZdm >=20 > Is this expected behavior with more than twice higher pgbench tps on > 1MB stripe size? No, it is not. For start, can you please repeat your benchmarks but with restarting the PostgreSQL server between each pgbench run? Also, you should make sure that the database is located on the same location on the disk platters by e.g. creating a small partition which is about 150% larger than your pgbench database (and your pgbench database should be at least 2x larger than your RAM, if you are going to benchmark IO and not memory caches), which is located at the same position (byte offset) in your RAID10 volume. ------enig2UBCEUFKHBCWAHTMQXKDM Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iEYEARECAAYFAlHa194ACgkQ/QjVBj3/HSzcsACgn/Z2oEbEzOYTUc+jxH8ZY90s y3AAoJel6Gebm0Wi0ScGFpMXrdo9PKv1 =Q4jH -----END PGP SIGNATURE----- ------enig2UBCEUFKHBCWAHTMQXKDM--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?krel4o$q96$1>