News for hackers. Stuff that matters.
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by sgarland on Tuesday April 08, 2025 @10:43PM (#43628428)
The advantage is when you want to store something for ease of use, but don’t want the disk (and memory, since pages read are loaded into the buffer pool) hit. So here, you could precompute the vector and index it, while not taking the double hit on size.
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by brightball on Wednesday April 09, 2025 @08:28PM (#43639432)
That’s the same benefit in Postgres as creating an index with the result of function.