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]).
Personally, I already view PostgreSQL comparable (for many use cases) to paid options[1].
Interesting, for queries such as:
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...