Re: Comparison of PgSQL Performance on HAMMER and UFS

2009-11-10 Thread Andrey N. Oktyabrski
jan.lent...@web.de wrote: I redid the tests as suggested and with a slighlty different test setup. Results attached. Next step: Redo the tests on -DEVELOPMENT. Can you add Solaris/OpenSolaris with UFS/ZFS in this test?

Re: Comparison of PgSQL Performance on HAMMER and UFS

2009-10-21 Thread Jan . Lentfer
Zitat von Matthew Dillon dil...@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

Re: Comparison of PgSQL Performance on HAMMER and UFS

2009-10-16 Thread Matthew Dillon
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): vfs.getattr_mpsafe=1 vfs.read_mpsafe=1

Re: Comparison of PgSQL Performance on HAMMER and UFS

2009-10-14 Thread Simon 'corecode' Schubert
jan.lent...@web.de wrote: those following IRC might know what this is about. For the rest: I did some performance testing of PostgreSQL on DF with HAMMER and UFS and the attached document is the (preliminary) result of that. Any comments/proposals are welcome. Especially if someone could comment