Just use Postgres for everything

Re:Just use Postgres for everything by CodeWriter23 on Saturday December 10, 2022 @01:43PM (#33935406)

I think GP may be referring to the use of GIN indexes https://www.postgresql.org/docs/current/textsearch-tables.ht...

[ Parent | on HN ]

Re:Just use Postgres for everything by jamal-kumar on Saturday December 10, 2022 @01:50PM (#33935507)

Yes 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!

[ Parent | on HN ]

Re:Just use Postgres for everything by CodeWriter23 on Saturday December 10, 2022 @08:56PM (#33939217)

I've used it successfully at admittedly a small scale to enable full text search of notes-type records on a TEXT field.

[ Parent | on HN ]

Re:Just use Postgres for everything by jefftk on Saturday December 10, 2022 @03:11PM (#33936336)

I 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!

[ Parent | on HN ]