> do full text search. And if you put all that together, you have a complex Postgres deployment.

search is also just extension? So, its a strong point: you have one self-contained server with simple installation/maintenance story.