Strategies for optimizing memory usage (buffer pools, work memory), connection pooling architectures (PgBouncer, ProxySQL), and system-level resource limits for stable multi-tenant operations