News for hackers. Stuff that matters.
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by brightball on Tuesday April 08, 2025 @10:23PM (#43628356)
I’ve been a Postgres FTS advocate for over a decade since replacing a Solr search with it and getting easier maintenance, more flexibility with queries and virtually no difference in speed.

It’s pretty great.

Elastic is on a different level for a lot of use cases, but pg is more than enough for the vast majority of workloads.

Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by therealdrag0 on Wednesday April 09, 2025 @12:25PM (#43633905)
What’s the biggest scale you’ve used Postgres search for?
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by brightball on Thursday April 10, 2025 @08:08AM (#43643018)
A site with about 300,000 users where we were still scaling it vertically.