Horrible PostgreSQL performance with NFS

Jim C. Nasby decibel at decibel.org
Wed Jan 18 16:59:00 PST 2006


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.
-- 
Jim C. Nasby, Database Architect                decibel at decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


More information about the freebsd-database mailing list