Date: Wed, 18 Jan 2006 17:11:15 -0800 From: Brooks Davis <brooks@one-eyed-alien.net> To: "Jim C. Nasby" <decibel@decibel.org> Cc: freebsd-database@freebsd.org, Slawek Zak <slawek.zak@gmail.com>, freebsd-performance@freebsd.org, Arne Woerner <arne_woerner@yahoo.com> Subject: Re: Horrible PostgreSQL performance with NFS Message-ID: <20060119011115.GA18415@odin.ac.hmc.edu> In-Reply-To: <20060119005847.GK17896@decibel.org> References: <787bbe1c0601140457y6de99891n86b49a728eedac94@mail.gmail.com> <20060114144202.6199.qmail@web30315.mail.mud.yahoo.com> <20060119005847.GK17896@decibel.org>
next in thread | previous in thread | raw e-mail | index | archive | help
--sm4nu43k4a2Rpi4c Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jan 18, 2006 at 06:58:47PM -0600, Jim C. Nasby wrote: > On Sat, Jan 14, 2006 at 06:42:02AM -0800, Arne Woerner wrote: > > Did you do those "dd" tests with small block sizes (like 1byte: > > bs=3D1), like somebody on one of those lists suggests, too? Then we > > could see, if there is a high latency that ruins everything... >=20 > FYI, PostgreSQL does 8kB I/O by default. This can only be changed by > modifying a header file. That's definitely small in my book (certainly compared to the 1MB block size the first responder suggested), knowing that, you should definitely do dd tests with 8k blocks since that's the best performance you are likely to get. -- Brooks --=20 Any statement of the form "X is the one, true Y" is FALSE. PGP fingerprint 655D 519C 26A7 82E7 2529 9BF0 5D8E 8BE9 F238 1AD4 --sm4nu43k4a2Rpi4c Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFDzuczXY6L6fI4GtQRAoNCAJ0dJcbZZyxaFn3+JPvgQjYNon3+DQCfXquj il7c4HKlug5OMn5bna5E0rE= =6iId -----END PGP SIGNATURE----- --sm4nu43k4a2Rpi4c--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060119011115.GA18415>