EmbeddingGemma 2: an open, lightweight multimodal embedding model
deepmind.google·6d ago
AI Engineering
Lobsters·Aug 20·5 min read
Poisoned Postgres connection pools
TL;DR
Improper management of Postgres connection pools can lead to severe database issues, including a read-only state. Understanding connection pooling is crucial for maintaining database performance and reliability.
✦ Why It Matters
Review your connection pool management practices to prevent potential database failures.
Key Takeaways
- Monitor connection pools for stale session states.
- Use 'DISCARD ALL' to reset poisoned connections.
- Route read traffic to replicas to prevent issues.
- Implement strict timeouts for transactions to avoid leaks.
How It Works
PgBouncer allows multiple client connections to share a limited number of database connections, improving scalability. When a client sets session attributes, these can persist and affect future queries if not properly managed, leading to a poisoned connection pool.