News for hackers. Stuff that matters.
Re:Creating an advanced search engine with PostgreSQL by softwaredoug on Wednesday July 12, 2023 @07:23PM (#36703040)
You might trade for a different problem, which is that search could end up being a very different query load on the Postgres cluster compared to existing queries. That might make it hard to scale it out for both use cases.
Re:Creating an advanced search engine with PostgreSQL by selcuka on Wednesday July 12, 2023 @07:58PM (#36703342)
You can always have a separate, streaming replica [1] used for full text searches.

[1] https://www.postgresql.org/docs/current/warm-standby.html#ST...