[EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: > [EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: > > > "Ken Hirsch" <[EMAIL PROTECTED]> writes: > > > > > I don't have a machine with XFS installed and it will be at least a week > > > before I could get around to a build. Any volunteers? > > > > I think I could do that... any useful benchmarks to run? > > In lack of bigger benchmarks, I tried postgresql 7.1 on a Red Hat > Linux 7.1 system with the SGI XFS modifications. The differences were > very small. And here is the one for ReiserFS - same kernel, but recompiled to turn off debugging
DB connection startup: 0.01user 0inputs+0outputs (208major+17minor)pagefaults 0swaps : 8192 INSERTs INTO SIMPLE (1 xact): real 0m5.857s : user 0m1.200s : sys 0m0.510s : 8192 INSERTs INTO SIMPLE (8192 xacts): real 0m37.036s : user 0m1.430s : sys 0m0.580s : Create INDEX on SIMPLE: 0.00user 0inputs+0outputs (209major+17minor)pagefaults 0swaps : 8192 INSERTs INTO SIMPLE with INDEX (1 xact): real 0m7.017s : user 0m1.180s : sys 0m0.420s : 8192 random INDEX scans on SIMPLE (1 xact): real 0m12.761s : user 0m1.670s : sys 0m0.820s : ORDER BY SIMPLE: 0.04user 0inputs+0outputs (214major+69minor)pagefaults 0swaps :
When compared to the earlier ones (including XFS), you'll note that ReiserFS performance is rather poor in some of the tests - it takes 37 vs. 13 seconds for 8192 inserts, when the inserts are different transactions. -- Trond Eivind Glomsrød Red Hat, Inc.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
