Updating TTL for ClickHouse is a resource intensive operation in general.
You would either want to temporarily increase the resources allotted to machine/pod where SigNoz ClickHouse is running.
Or you could disable the ingestion and after the resource usage settles before proceeding with the TTL updation.