Re: Horrible PostgreSQL performance with NFS

2006-01-18 Thread Jim C. Nasby
On Wed, Jan 18, 2006 at 05:11:15PM -0800, Brooks Davis wrote: > 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

Re: Horrible PostgreSQL performance with NFS

2006-01-18 Thread 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 l

Re: Horrible PostgreSQL performance with NFS

2006-01-18 Thread Jim C. Nasby
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 defau