We've been playing around with new Phrase Text feature of full-text PostgreSQL 9.6. In doing so, I was curious how big a number one can designate as max that words can be apart. I discovered thru trial and error, that the magic number is 16384 which is much bigger than I had suspected.

Continue reading "PostgreSQL 9.6 phrase text searching how far apart can you go"