We've solved this ("any of these N related tables needs to update the search record") but building reactivity into our backend ORM: https://joist-orm.io/docs/a

We've solved this ("any of these N related tables needs to update the search record") but building reactivity into our backend ORM: https://joist-orm.io/docs/advanced/full-text-search https://joist-orm.io/docs/advanced/full-text-search Granted, currently we still do pgsearch against this derived field, but could sync it over to ES.