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 codesnik on Tuesday April 08, 2025 @10:34PM (#43628399)
It's not only an additional disk space, it also a need to sync it with main column, using triggers or whatever, and have much bigger backups. Why "initial instinct was to question", though? I don't see downsides still, unless yeah, weighted queries or need to search in joined tables etc.
[ Parent | on HN ]
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by aobdev on Tuesday April 08, 2025 @10:53PM (#43628466)
It's a generated column, so there's no overhead to keep it up to date, but all generated columns in PG are stored. The corpus for text search will be stored 1x in the source column, 1x as a tsvector in the index, and an additional 1x in the generated column if you do so. That's a 50% increase in disk space.
[ Parent | on HN ]
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by cryptonector on Wednesday April 09, 2025 @01:17AM (#43629097)
There is still the overhead of updating that extra space.
[ Parent | on HN ]