[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.
DB connection startup: 0.01user 0inputs+0outputs (208major+17minor)pagefaults 0swaps : 8192 INSERTs INTO SIMPLE (1 xact): real 0m5.871s : user 0m0.990s : sys 0m0.460s : 8192 INSERTs INTO SIMPLE (8192 xacts): real 0m13.347s : user 0m1.420s : sys 0m0.530s : Create INDEX on SIMPLE: 0.01user 0inputs+0outputs (209major+17minor)pagefaults 0swaps : 8192 INSERTs INTO SIMPLE with INDEX (1 xact): real 0m6.938s : user 0m1.160s : sys 0m0.420s : 8192 random INDEX scans on SIMPLE (1 xact): real 0m12.831s : user 0m1.700s : sys 0m0.970s : ORDER BY SIMPLE: 0.07user 0inputs+0outputs (214major+69minor)pagefaults 0swaps :
DB connection startup: 0.02user 0inputs+0outputs (208major+17minor)pagefaults 0swaps : 8192 INSERTs INTO SIMPLE (1 xact): real 0m5.652s : user 0m1.080s : sys 0m0.530s : 8192 INSERTs INTO SIMPLE (8192 xacts): real 0m13.021s : user 0m1.280s : sys 0m0.380s : Create INDEX on SIMPLE: 0.01user 0inputs+0outputs (209major+17minor)pagefaults 0swaps : 8192 INSERTs INTO SIMPLE with INDEX (1 xact): real 0m6.912s : user 0m1.100s : sys 0m0.530s : 8192 random INDEX scans on SIMPLE (1 xact): real 0m12.745s : user 0m1.660s : sys 0m0.940s : ORDER BY SIMPLE: 0.04user 0inputs+0outputs (214major+70minor)pagefaults 0swaps :
DB connection startup: 0.01user 0inputs+0outputs (208major+17minor)pagefaults 0swaps : 8192 INSERTs INTO SIMPLE (1 xact): real 0m5.649s : user 0m1.000s : sys 0m0.540s : 8192 INSERTs INTO SIMPLE (8192 xacts): real 0m13.115s : user 0m1.390s : sys 0m0.490s : Create INDEX on SIMPLE: 0.01user 0inputs+0outputs (209major+17minor)pagefaults 0swaps : 8192 INSERTs INTO SIMPLE with INDEX (1 xact): real 0m6.827s : user 0m1.240s : sys 0m0.560s : 8192 random INDEX scans on SIMPLE (1 xact): real 0m12.653s : user 0m1.790s : sys 0m0.830s : ORDER BY SIMPLE: 0.01user 0inputs+0outputs (214major+69minor)pagefaults 0swaps :
-- Trond Eivind Glomsrød Red Hat, Inc.
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
