PostgreSQL 11 and Just in Time Compilation of Queries
I'm curious if we will see similar improvements for full-text search. If PostgreSQL continues to improve at this rate, there will be little reason to use many of alternatives...Personally, I already view PostgreSQL comparable (for many use cases) to paid options[1].Interesting, for queries such as:   EXPLAIN ANALYZE SELECT * FROM (SELECT * FROM sort1 ORDER BY 1) AS a LIMIT 5 ;

You'll see an order of magnitude speed improvement (page 47 of [2]).[1] https://austingwalters.com/fast-full-text-search-in-postgres...[2] https://h50146.www5.hpe.com/products/software/oe/linux/mains...