main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size

Magento 2.4.5-p1
Smartwave Porto theme

I have found the following Error in my logs:

main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 100000; Allocated memory size: 1300000000 bytes; InnoDB buffer pool size: 2147483648 bytes.

I googled it and found the following article:

Magento 2 Please update innodb_buffer_pool_size or decrease batch size value

It suggests to update default Batching configuration of catalog_category_product (Category Products) indexer because “Current batch size: 100000” and points to this article here:

https://developer.adobe.com/commerce/php/development/components/indexing/optimization/

I’ve raised this with our hosting and they responded with:

On the server end we can increase the ‘innodb_buffer_pool_size’ value, as per the update of Batching configuration of catalog_category_product, it requires tweaking of the Magento 2 coding, which is a matter that falls outside our scope of expertise.
Currently, ‘innodb_buffer_pool_size’ is set to 2 GB, upon your request, we can increase it to 4 GB or 8 GB.

I am honestly lost. What do I need to do?