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
pgpL3BqCKUfzF.pgp
Description: PGP signature
