High memory consumption on MERGE INTO

N1QL
1

Hi everyone!
I had some unexpected high memory consumption with trying to do an inserting or updating records with a query similar to

MERGRE INTO products AS dst 
USING [
       {"type":"ra::p", "vendor_code":"xxx", ...}
]` src
ON KEY "ra::p::" || src.`vendor_code`
 WHEN MATCHED THEN UPDATE SET 
...
 WHEN NOT MATCHED THEN INSERT {
...
}

While I’m trying to update/insert 75k of records (by 1000 or 100 or even 1 ) soon or later the index service eats all available node memory. I’m doing sequently writes from Go SDK. Couchbase 6.5.1 CE. 8GB RAM total, 3-4 GB free RAM on operation start. Any ideas?

2

Merge is Mutations Index might be updating. cc @jeelan.poola

3

Bump. Any suggestions?