eg look at the pg docs re: at least 5 different types of indices are implemented https://www.postgresql.org/docs/current/indexes.html

Everything is like that.

(I'm not bashing sqlite, it's great software, but it has a tiny fraction of the product footprint that pg has.)

And that's just core, not even including built-in extensions like bloom.