Just use Postgres for everything

Re:Just use Postgres for everything by quickthrower2 on Saturday December 10, 2022 @03:33PM (#33936524)

Surely you give up LIKE queries benefiting from the index this way?

[ Parent | on HN ]

Re:Just use Postgres for everything by necovek on Sunday December 11, 2022 @08:46AM (#33943121)

Last time I needed this, LIKE queries still did sequential scans anyway, so the presence of an index or not did not matter.

Also note that you can have multiple indexes in Postgres (well, any RDBMS).

For emails in particular, you can even do partial indexes (eg. imagine filtering emails on @gmail.com to hit a separate index that's only half of your full table index). This requires some care with queries, but a wonderful feature regardless.

[ Parent | on HN ]

Re:Just use Postgres for everything by tpetry on Monday December 12, 2022 @05:54AM (#33953302)

With a trigram index in PostgreSQL you can even do index-supported leading wildcard searches.

[ Parent | on HN ]