News for hackers. Stuff that matters.
Re:What Postgres Full Text Search Is Missing by nemo44x on Tuesday August 06, 2024 @07:05PM (#41176443)
It’s why you need “enough” data. Generally the distribution of teens is a power-law distribution. There’s a set of common terms and a very long tail of other terms. This will be the case across every shard if you do in fact have enough data per shard. This becomes a factor in certain distributed aggregations as well. YMMV of course.

In general you trade accuracy for speed. You tend to get a lot of speed for just a small amount of accuracy sacrifice.

Re:What Postgres Full Text Search Is Missing by sroussey on Wednesday August 07, 2024 @12:52AM (#41178350)
Oh sure, but it is a side channel attack to be aware of.