@tron why do you need to query with Regex in the same transaction? In general, we just grab the uid and do the next insertions until we commit. I can’t see why you are doing like this.
As far I know, the transaction stays in RAM until you commit. So, it won’t have any index or way to access. Only the Upsert Procedure could. You can try to use this Upsert