carloea2 commented on issue #5142: URL: https://github.com/apache/texera/issues/5142#issuecomment-4530500446
I agree content search should be preserved, but today it is coupled to the hot write path: `/workflow/persist` writes directly to `workflow`, and the PGroonga index is on `workflow.content`, so every insert/update must synchronously update that index. So I think the fix should be two-stage: 1. Unblock heavy workflow saves first by removing/limiting `content` from the synchronous PGroonga index, or changing the tokenizer/timeouts so JSON content cannot hang writes. 2. Restore safer content search separately through an async index path, e.g. a search table/queue updated after the workflow transaction commits. Maybe @mengw15 or @Ma77Ball have some better solution? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
