News for hackers. Stuff that matters.
Re:Why Uber Engineering Switched from Postgres to MySQL by philliphaydon on Wednesday July 27, 2016 @12:28AM (#12170530)
I was testing some JSONB indexing and did a date-range query on a json doc for a table with 100m records to test with, it returned top 10 records that met the criteria in ~4s, figured out how to index the json doc for dates and this dropped to ~25ms.

This was running on an old Core i5 / 16gb of ram with a lot of junk running on Windows.

It would probably have been faster on a production environment.

There are no comments on this comment yet.