Re: Horrible PostgreSQL performance with NFS
"Jim C. Nasby" <[email protected]>
| Newsgroups | gmane.os.freebsd.devel.database |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected] 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?" _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-database To unsubscribe, send any mail to "[email protected]"