Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST

Can lots of merge results cause high CPU usage

Knowledge Drop

Last tested: Oct 28, 2020

Answer is yes!

Merge results are performed in memory and not in SQL on the database. We store the results of all the source queries in memory and then merge those source queries in memory. The usage of this memory can cause the memory to be throttled (essentially meaning that memory is used up to its max).

When the memory is throttled, it can trigger the garbage collector, and thus causes high CPU usage.

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:14 PM
Updated by: