I use PostgreSQL a lot but these benchmarking results surprise me. MySQL is often much faster than PostgreSQL and SQLLite is several times faster than MySQL.
What matters to me is how fast they work with Python, or in particular Zope. I need to make my own benchmark of MySQL and PostgreSQL with Zope and all the various database adapters.
The reason I moved from MySQL to PostgreSQL was partly because PostgreSQL has more enterprise features and that my colleges use PostgreSQL. But I suspect that for many of my projects I never even use these features.
Then I also found this from a Zope mailing list:
>The speed comparisions with PostgreSQL are very much an apples vs. fish
>sort of thing: the pgsql server was not tuned at all, and does a whole
>lot more that was never tested, such as multi-user writer access.
- Challenge Osama with scimitar or sword
02 April 2004
- XHTML, HTML and CSS compressor
07 April 2004
- How do log ALL PostgresSQL SQL happening
20 July 2015
- Benchmarking Autocompeter
12 April 2015
- Fastest database for Tornado
09 October 2013
- django-fancy-cache with or without stats
11 March 2013
- Postgres collation errors on CITEXT fields when upgrading to 9.1
21 May 2012
- Connecting with psycopg2 without a username and password
24 February 2011
- Optimization of getting random rows out of a PostgreSQL in Django
23 February 2011
- Fastest "boolean SQL queries" possible with Django
14 January 2011
- Local Django development with Nginx
11 October 2010
- UPPER vs. ILIKE
19 April 2010