PostgreSQL 11 and Just in Time Compilation of Queries
I&#x27;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&#x27;ll see an order of magnitude speed improvement (page 47 of [2]).<p>[1] <a href="https:&#x2F;&#x2F;austingwalters.com&#x2F;fast-full-text-search-in-postgresql&#x2F;" rel="nofollow">https:&#x2F;&#x2F;austingwalters.com&#x2F;fast-full-text-search-in-postgres...</a><p>[2] <a href="https:&#x2F;&#x2F;h50146.www5.hpe.com&#x2F;products&#x2F;software&#x2F;oe&#x2F;linux&#x2F;mainstream&#x2F;support&#x2F;lcc&#x2F;pdf&#x2F;PostgreSQL_11_New_Features_beta1_en_20180525-1.pdf" rel="nofollow">https:&#x2F;&#x2F;h50146.www5.hpe.com&#x2F;products&#x2F;software&#x2F;oe&#x2F;linux&#x2F;mains...</a>