3 ms·
I think GP may be referring to the use of GIN indexes https://www.postgresql.org/docs/current/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX https://www.postgre
by CodeWriter23 4y ago
I think GP may be referring to the use of GIN indexes https://www.postgresql.org/docs/current/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX https://www.postgresql.org/docs/current/textsearch-tables.ht...
- jamal-kumar 4y agoYes that. When you get over a million users... I've yet to try the index of hashed values trick though, when I revisit this problem in the future I'll make sure to take note of this!
- CodeWriter23 4y agoI've used it successfully at admittedly a small scale to enable full text search of notes-type records on a TEXT field.
- jefftk 4y agoI was worried they were talking about doing it manually, and was thinking "surely there's a built-in way to create a hashed index" -- Glad to learn there is!