Horrible PostgreSQL performance with NFS

[Brooks Davis]

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=1), like somebody on one of those lists suggests, too? Then we
> > could see, if there is a high latency that ruins everything...
> 
> 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

-- 
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-performance/attachments/20060118/46c17bff/attachment.bin