Vector databases, so hot right now. I haven't really looked into them, I'm just wondering when or if postgres will do it better?

It already does and it’s free - https://github.com/pgvector/pgvector

Only a sucker being forced to by their investors would use pinecone.