Date: Thu, 19 Jan 2006 10:05:32 -0800 From: Sean Chittenden <sean@gigave.com> To: Brooks Davis <brooks@one-eyed-alien.net> Cc: freebsd-database@freebsd.org, freebsd-performance@freebsd.org, Arne Woerner <arne_woerner@yahoo.com>, "Jim C. Nasby" <decibel@decibel.org> Subject: Re: Horrible PostgreSQL performance with NFS Message-ID: <20060119180533.4B8FC21701B@mailhost.gigave.com> In-Reply-To: <20060119011115.GA18415@odin.ac.hmc.edu> References: <787bbe1c0601140457y6de99891n86b49a728eedac94@mail.gmail.com> <20060114144202.6199.qmail@web30315.mail.mud.yahoo.com> <20060119005847.GK17896@decibel.org> <20060119011115.GA18415@odin.ac.hmc.edu>
next in thread | previous in thread | raw e-mail | index | archive | help
--qVHblb/y9DPlgkHs Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable > > > 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. >=20 > 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. PostgreSQL can be configured to use more than 32K blocks, but I recall 65K having problems and shouldn't be used in production. Tom Lane was less than amused when he found out I'd added those options to the ports and issued some strong words suggesting against using anything but 8K blocks simply because that was the only config that'd seen years of production use. YMMV. -sc --=20 Sean Chittenden --qVHblb/y9DPlgkHs Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- iD8DBQFDz9Tsapga0yeGcOQRAnwjAJ9Q6DVDVGIMKpvauh5RwfdaoIMWtwCgxPJ3 /YO8k5TFeePgp7rPIawg16Q= =eFD6 -----END PGP SIGNATURE----- --qVHblb/y9DPlgkHs--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060119180533.4B8FC21701B>