Probable faq: need some benchmarks of pgsql vr.s mysql
От | Brian Hurt |
---|---|
Тема | Probable faq: need some benchmarks of pgsql vr.s mysql |
Дата | |
Msg-id | alpine.DEB.2.00.1010290839400.31170@sergyar обсуждение исходный текст |
Ответы |
Re: Probable faq: need some benchmarks of pgsql
vr.s mysql
Re: Probable faq: need some benchmarks of pgsql vr.s mysql Re: Probable faq: need some benchmarks of pgsql vr.s mysql |
Список | pgsql-advocacy |
My company is currently hitting a problem with mysql/innodb having really slow insert performance (we're seeing ~1K rows/second). My boss wants to go and spend a bunch of money on the Tokutek backend. I'd rather we save the money and go to postgres instead. We're not heavily invested in mysql at this point (fixing our queries to switch from mysql to postgres would take about five minutes). But my boss wants to see some benchmarks. 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: 1) Comparing Postgres to MyISAM. Transactions are not an option for us, so it doesn't matter if MyISAM is a hundred times faster. I want to compare Postgres to InnoDB (bonus points for Postgres vr.s Tokutek). 2) Using the default configurations. Be serious- is there any one who cares the least about performance who uses the default configuration? 3) Using old versions of Postgres. I'd like the survey to at least use the 8.x series, bonus points for it being 9.x. 4) Not using COPY for inserts. We would, of course, be using the copy command for inserts. Here's the thing. I have personally seen postgres 8.1 insert 30K rows/second, in to a real table, on crappy hardware (single slow IDE drive, old crappy hardware). I would be shocked if I can't improve on the InnoDB numbers by at least an order of magnitude. I'm whipping together a personal benchmark to show this. But I need a "professional looking" benchmark, with pretty charts and graphs and etc., to back me up. Help? Brian
В списке pgsql-advocacy по дате отправления: