Alexander Korotkov

akorotkov.github.io

Long story short, since PostgreSQL 14 to_tsquery('pg_class') becomes 'pg' <-> 'class' instead of 'pg' & 'class' ( commit 0c4f355c6a ). That is for instance, in PostgreSQL 13 and earlier to_tsquery('pg_class') matches to_tsvector('a class of pg') . But since PostgreSQL 14 it doesn’t match, but still matches…

Popular posts: 1
Total points: 521
HN comments: 210
Rank: #4,899 personal

Visit akorotkov.github.io → RSS feedOn Hacker News May 2016 – May 2016

Systems & Performance 1 Databases & Data 1

Most points Most discussed Most cited Newest

PostgreSQL Scalability: Towards Millions TPS

2016521 points210 commentscited by 5Databases & Data details

PostgreSQL scalability on multicore and multisocket machines became a subject of optimization long time ago once such machines became widely used. This blog post shows brief history of vertical scalability improvements between versions 8.0 and 8.4. PostgreSQL 9.2 had very noticeable scalability improvement. Thanks to…