News for hackers. Stuff that matters.

A comment on PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth). Parent comment

Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by VoVAllen on Tuesday April 08, 2025 @10:25PM (#43628365)
It's coming in the Postgres 18. https://www.depesz.com/2025/02/28/waiting-for-postgresql-18-...
[ Parent | on HN ]
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by sgarland on Tuesday April 08, 2025 @10:39PM (#43628415)
Yes (very exciting!), but you won’t be able to index them, and that’s really where they shine, IMO.

Still, I’m sure they’ll get there. Maybe they’ll also eventually get invisible columns, though tbf that’s less of a problem for Postgres as it is for MySQL, given the latter’s limited data types.

[ Parent | on HN ]
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by danielheath on Wednesday April 09, 2025 @03:16AM (#43629630)
You can index arbitrary expressions, though, including indexing the same expression used to define the invisible column, right?
[ Parent | on HN ]