DragonFly BSD
DragonFly users List (threaded) for 2009-10
[Date Prev][Date Next]  [Thread Prev][Thread Next]  [Date Index][Thread Index]

Re: Comparison of PgSQL Performance on HAMMER and UFS

From: Jan.Lentfer@xxxxxx
Date: Wed, 21 Oct 2009 16:25:58 +0200

Zitat von Matthew Dillon <dillon@apollo.backplane.com>:

    I'd like to see how those results compare with the various
    MPSAFE sysctls turned on, and also with fsync disabled (so
    we can get an idea how badly fsync effects write transactions,
    since we know fsync is very expensive on HAMMER):




    And also with the recent buffer cache work on master.
    The meta-data for a 5GB dataset should be cachable but
    prior to the work buffer cache data was being thrown out
    of the backing VM page caches too quickly.

    Another thing we know about HAMMER is that the initial
    B-Tree layout is pretty horrible.  It takes a reblocking
    pass to fix it up.  It shouldn't effect a dataset that
    small with the cache priorities fixed in master, though.


I redid the tests as suggested and with a slighlty different test setup. Results attached. Next step: Redo the tests on -DEVELOPMENT.



---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

Attachment: HAMMER_pgsql.pdf
Description: Adobe PDF document

[Date Prev][Date Next]  [Thread Prev][Thread Next]  [Date Index][Thread Index]