> I get ~50 tps for any commit_delay value > 0. I've tried many values in the > range 0 - 999, and always get ~50 tps. commit_delay=0 always gets me ~200+ > tps. > > Yes, I have tried multiple clients but got stuck on the glaring difference > between versions with a single client. The tests that I ran showed the same > kind of results you got earlier today i.e. 1 client/1000 transactions = 10 > clients/100 transactions. > > So, is it OK to use commit_delay=0? commit_delay was designed to provide better performance in multi-user workloads. If you are going to use it with only a single backend, you certainly should set it to zero. If you will have multiple backends committing at the same time, we are not sure if 5 or 0 is the right value. If multi-user benchmark shows 0 is faster, we may change the default. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- Re: [ADMIN] v7.1b4 bad performance Tom Lane
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- Re: [ADMIN] v7.1b4 bad performance Tom Lane
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- Re: [ADMIN] v7.1b4 bad performance Tom Lane
- Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Tatsuo Ishii
- Re: [ADMIN] v7.1b4 bad performance Thomas Lockhart
- Re: [ADMIN] v7.1b4 bad performance Tatsuo Ishii
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Hiroshi Inoue
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performanc... Hiroshi Inoue
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad perfor... Hiroshi Inoue
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- RE: [ADMIN] v7.1b4 bad performance The Hermit Hacker
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- RE: [ADMIN] v7.1b4 bad performance Michael Ansley