Just Use Postgres for Everything

this is 100% true.

"complexity very, very bad" - https://grugbrain.dev/

I agree. I did this myself with TxtAI. It can store vectors, data, graphs and keyword indexes all to Postgres. https://medium.com/neuml/postgres-is-all-you-need-for-vector...

for text search in postgr5esql, try rum index from postgrepro.

https://postgrespro.com/blog/pgsql/4262305