…Percona runs Percona Performance Conference as a free event going concurrently with the conference and announced Percona XtraDB as improved… other databases and technologies in NoSQL and BigData space – PostgreSQL, EnterpriseDB, Hadoop,Hbase, MongoDB, CouchBase providing compliments and alternatives …
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… much information about how MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit different implementations (ie… this level at higher concurrency. MySQL with Innodb shows its ugly face and drops pretty quickly as concurrency growths with peak at…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… about interesting benchmarks Tweakers.net have done for MySQL and PostgreSQL with different CPUs. I was in contact with Tweakers.net… matching PostgreSQL 8.2 results Same as in previous test PostgreSQL is winner with large margin especially when it comes to higher concurrency… still have massive scalability drop with increasing concurrency – going from 10 to 20 concurrent connections drops performance from about 620 to 450…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…=24M read_buffer_size=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8… our hardware and our system administrators 
When we switched to PostgreSQL, there was no such issue. We do a “VACCUM” every… budget to throw all that staff, or time, at it. PostgreSQL solved it for us. Sorry for mentioning this on a…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… have numerous performance improvements which benefit workloads that have high concurrency. Typical OLTP workloads feature numerous clients (perhaps hundreds or thousands…-Query can be extended to other database servers such as PostgreSQL or Firebird fairly easily. What machine did I use? I…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… see for example results on the same hardware just running PostgreSQL instead of MySQL or having Sun box replaced with comparable…_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40 innodb_locks_unsafe_for… log for a little bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… of things which can be hardware related (CPU and disk concurrency), some are environment related – log flushing on transaction commit, size… it in current Limits section though. Isolation Modes: Innodb, Oracle, PostgreSQL also support MVCC but frequently offer it in different way… – it can backfire as load growths and so concurrency increases – on low concurrency even MyISAM with table level locks does just fine…
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
February 1, 2010 By 16 Comments
… you should also try to do is simulate concurrent access by firing multiple concurrent query streams. Some database are fast when running… where I ran TPCH using Greenplum and got discussions between PostgreSQL and GP advocates… anyway, good luck with the benchmark and…
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
… blog’s subject. You have probably seen these benchmarks comparing PostgreSQL and MySQL performance, which show how bad MySQL scales on…: http://tweakers.net/reviews/649/7 The problem with high concurrency starts with 4 cores and becomes dramatic with 6-8…’re using MySQL in a 4+ cores system with high concurrency.
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… FOR UPDATE. This is also why Falcon has Optimistic locking concurrency which can give you problems if you have lock intensive… from it after it was implemented. Speaking with Oracle and PostgreSQL developers it looks like they all acknowledge this problem and…
