EmbeddingGemma 2: an open, lightweight multimodal embedding model
deepmind.google·6d ago
AI Engineering
Hacker News·Jul 24·5 min read
Postgres LISTEN/NOTIFY actually scales
TL;DR
Postgres LISTEN/NOTIFY can effectively scale for low-latency notifications, achieving 60K writes per second with millisecond latency. This challenges previous notions about its performance limitations.
✦ Why It Matters
Consider implementing LISTEN/NOTIFY for your Postgres applications to enhance real-time data handling.
Key Takeaways
- Implement notification buffering to improve throughput.
- Batch notifications to reduce contention on global locks.
- Use fallback polling for undelivered notifications.
- Benchmark performance to ensure system saturation.
How It Works
The optimization involves buffering notifications in memory and periodically flushing them in a single batch transaction. This reduces the need for the global lock to be held during each individual stream write, allowing for higher throughput and better resource utilization.