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.
[ Parent
| on HN ]
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...