Mautic Hangs or Takes forever to open a Large Segment

Hi,

I have a question, we have a relatively strong instance of Mautic running on a 4 Dedicated CPU and 8GB of Ram only for the application server, the DB server is 32 Dedicated CPU and 64GB of RAM.

My problem is when trying to open a big segment I am getting timeouts. Any thoughts?

We have tweaked the number of child workers accordingly and in general the system runs very fast