On Mon, 2004-11-29 at 16:01 -0800, Mark Wong wrote: > I have some initial results using 8.0beta5 with our OLTP workload. > Off the bat I see about a 23% improvement in overall throughput. The > most significant thing I've noticed was in the oprofile report where > FunctionCall2 and hash_seq_search have moved down the profile a bit. > > Also, I have libc with symbols now so we can see what it's doing with > in the oprofile output. > > 8.0beta5 results: > http://www.osdl.org/projects/dbt2dev/results/dev4-010/199/ > throughput: 4076.97 > > 8.0beta4 results: > http://www.osdl.org/projects/dbt2dev/results/dev4-010/191/ > throughput: 3323.07
It appears that WAL archiving (archive_command) is configured in 191 and disabled (unset) in 199. Perhaps this accounts for some of the difference? -- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly