3 ms·
Not only was that a good outcome because 5m-8m isn't "big", there's even a more performant way to do real text search within Postgres that would let you scale f
by gdulli 11y ago
Not only was that a good outcome because 5m-8m isn't "big", there's even a more performant way to do real text search within Postgres that would let you scale far beyond that number before outgrowing it.
- Johnny555 11y agoWhether or not full text search is more scalable than a full table scan depends on the use case - if he's continually inserting and deleting rows from his table while doing relatively few queries, it may very well be more scalable to do the full table scans to avoid the continual overhead of maintaining the full-text index on inserts and deletes.
- gdulli 11y agoGood point.