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...<p>Personally, I already view PostgreSQL comparable (for many use cases) to paid options[1].<p>Interesting, for queries such as:<p><pre><code> EXPLAIN ANALYZE SELECT * FROM (SELECT * FROM sort1 ORDER BY 1) AS a LIMIT 5 ;
</code></pre>
You'll see an order of magnitude speed improvement (page 47 of [2]).<p>[1] <a href="https://austingwalters.com/fast-full-text-search-in-postgresql/" rel="nofollow">https://austingwalters.com/fast-full-text-search-in-postgres...</a><p>[2] <a href="https://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_11_New_Features_beta1_en_20180525-1.pdf" rel="nofollow">https://h50146.www5.hpe.com/products/software/oe/linux/mains...</a>