gperrone
06/14/2024, 6:30 PMMarvin
06/14/2024, 6:30 PMshared_buffers
and work_mem
to fit the instance's available memory without exhausting it.
Useful Links:
- AWS RDS Performance Insights Documentation
- PostgreSQL Memory Management
- AWS RDS Monitoring with CloudWatch
If you need specific examples for connection pooling or changing RDS configurations via Prefect, let me know, and I can provide code snippets!
Nonetheless, here’s a brief overview of how memory is managed which might help you introspect further:
- Prefect Managed Execution
Keep monitoring and tweaking as required. If all else fails, scaling up might be your best bet.
(Note: Do remember to check if your instance is correctly sized and if your workloads align with the current configuration capacity.)Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.
Powered by