BTW, what -B setting were you running the postmaster with? While poking
at this, I was reminded that having adequate buffer space really makes
a considerable difference ... especially under WAL, where it's not
necessary to flush dirty buffers to disk at the end of each transaction.
The default -B 64 is certainly too small to get reasonable performance.
I got roughly twice the tps reading (pgbench -t 1000, with -F) at -B 1024.
regards, tom lane
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- Re: [ADMIN] v7.1b4 bad performance Tom Lane
- Re: [ADMIN] v7.1b4 bad performance Karel Zak
- RE: [ADMIN] v7.1b4 bad performance Michael Ansley
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- 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 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: [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
