Horrible PostgreSQL performance with NFS

[Jim C. Nasby]

On Sun, Jan 22, 2006 at 11:49:36AM +0100, Oliver Fromme wrote:
> FWIW, there is _no_ blocksize that can be used wit dd(1)
> that benchmarks disks the same way a database does.
> Unless our dd(1) implemetation grew a random-seek option
> that I missed.  :-)
> 
> But seriously...  dd(1) is NOT a benchmark.  Never ever.
> Especially if you're interested in database performance.

OLAP databases depend heavily on sequential scans, which are the same as
dd. dd is also useful to find out what your maximum throughput is.
-- 
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?"