troubleshooting

How can I diagnose increasing memory usage in my RW meta node with Postgres backend?

I noticed my RW meta node has its memory usage steadily increasing with only sources and sinks, no materialized views or tables. Using Postgres meta backend. Memory usage has increased by ~50% in less than a day. Is there a way to diagnose why it's happening? Or is this a known issue?

Ne

Neil

Asked on Apr 17, 2024

  • Check for any memory leaks in the Postgres meta backend
  • Monitor the queries being executed and their memory consumption
  • Look for any long-running transactions that might be causing memory bloat
  • Consider optimizing the database schema and queries to reduce memory usage
  • Experiment with different configurations to see if they affect memory usage
Apr 17, 2024Edited by