---
title: "Beyond Query Optimization: Aurora Postgres Connection Pooling with SQLAlchemy & RDSProxy"
url: https://daily.dev/posts/beyond-query-optimization-aurora-postgres-connection-pooling-with-sqlalchemy-rdsproxy-nzy28mxay
source_url: https://eng.lyft.com/beyond-query-optimization-aurora-postgres-connection-pooling-with-sqlalchemy-rdsproxy-200db7f562d7
type: article
source: "Lyft Engineering"
published: 2025-05-20T13:23:15.525Z
updated: 2025-05-20T13:23:33.430Z
tags: ["python", "aws"]
reading_time: 15
upvotes: 3
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Beyond Query Optimization: Aurora Postgres Connection Pooling with SQLAlchemy & RDSProxy

**[Lyft Engineering](https://daily.dev/sources/lyfteng)** · 15 min read · 3 upvotes · 0 comments

## Summary

Efficient database connection management is crucial for performance, especially for high-scale applications. Connection pooling can drastically reduce the overhead of opening and closing database connections, improving scalability and resource utilization. Lyft's adoption of a proxy-based connection pooling solution using AWS RDSProxy demonstrated reduced database connections, improved application availability, and better CPU performance. However, challenges like session pinning and query latency still need addressing. RDSProxy provides significant improvements for managing connections in distributed applications.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://eng.lyft.com/beyond-query-optimization-aurora-postgres-connection-pooling-with-sqlalchemy-rdsproxy-200db7f562d7>

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments

---

Tags: [#python](https://daily.dev/tags/python), [#aws](https://daily.dev/tags/aws)

[View this post on daily.dev](https://daily.dev/posts/beyond-query-optimization-aurora-postgres-connection-pooling-with-sqlalchemy-rdsproxy-nzy28mxay)