> "Schmidt, Peter" <[EMAIL PROTECTED]> writes: > > So, is it OK to use commit_delay=0? > > Certainly. In fact, I think that's about to become the default ;-) I agree with Tom. I did some benchmarking tests using pgbench for a computer magazine in Japan. I got a almost equal or better result for 7.1 than 7.0.3 if commit_delay=0. See included png file. -- Tatsuo Ishii
- 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: [ADMIN] v7.1b4 bad performance Bruce Momjian
- 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
- RE: [ADMIN] v7.1b4 bad performance Michael Ansley
performance.png