Re: Probable faq: need some benchmarks of pgsql vr.s mysql

Brian,

My company is currently hitting a problem with mysql/innodb having
really slow insert performance (we're seeing ~1K rows/second).

As others have said, there's clearly something wrong with your setup and/or application which would likely affect PostgreSQL as well. I can name several ways in which PostgreSQL is better than MySQL/InnoDB, but insert performance isn't one of them.

My boss
wants to go and spend a bunch of money on the Tokutek backend.

I'm sure that Tokutek would be thrilled to have a customer (they're very new).  Again, though, insert performance isn't Tokutek's specialty; the arguments for using them is that (a) they're not owned by oracle, 

 > I've googled around for a while, but all the benchmarks I've found

commit one or more "fatal flaws", which render the benchmark pointless
at best:

Doing real benchmarks is an involved, expensive process, and both DBMSes are fast-moving targets which need to be benchmarked every year.  I've talked with Percona about doing some MySQL vs. PostgreSQL head-to-heads, but in the absence of specific funding that's unlikely to be completed.  Besides, we both really want to do head-to-heads with MSSQL & Oracle, not each other.