> "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: [HACKERS] [ADMIN] v7.1b4 bad performance Dmitry Morozovsky
- Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- Re: [ADMIN] v7.1b4 bad performance Dmitry Morozovsky
- Re: [ADMIN] v7.1b4 bad performance Dmitry Morozovsky
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad pe... Dave Mertens
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad pe... Tom Lane
- Re: [HACKERS] Re: [ADMIN] v7.1b4 b... Tatsuo Ishii
- Re: [HACKERS] Re: [ADMIN] v7.1... Tom Lane
- Re: [HACKERS] Re: [ADMIN] v7.1... Tatsuo Ishii
- RE: [HACKERS] Re: [ADMIN] v7.1b4 b... Hiroshi Inoue
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Tatsuo Ishii
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Tom Lane
- [HACKERS] Re: [ADMIN] v7.1b4 bad performance Thomas Lockhart
- [HACKERS] Re: [ADMIN] v7.1b4 bad performance Tatsuo Ishii
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Larry Rosenman
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Dmitry Morozovsky