I am running temporal with Postgresql 11. Postgresql server experiences a sudden increase in CPU consumption whenever there is a slight jump in requests per minute. Can you please guide me how can I debug this ? Postgresql has 8 cores. There are 8 history pods with 1 core / 1 GB each. 2 frontend and 2 matching pods with same resources.
Each request starts a new workflow or issues a signal if workflow is already running.
- Workflow waits for few signals
- Workflow contains 10-30 Activity calls.
- Several activities which typically take less than 1 seconds are local activities. Rest of the activities finish in less than 5 seconds.