# PgBouncer: The one with prepared statements

DevFeed: [PgBouncer: The one with prepared statements](<https://devfeed.tech/articles/pgbouncer-the-one-with-prepared-statements-5717.md>)

Original publisher: [Read original article](<https://neon.com/blog/pgbouncer-the-one-with-prepared-statements>)

Author: Raouf Chebri

Published: 2024-02-15T09:43:20Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [backends](<https://devfeed.tech/topics/backends.md>), [Processes](<https://devfeed.tech/topics/processes.md>), [Concurrent Programming](<https://devfeed.tech/topics/concurrent-programming.md>), [Security](<https://devfeed.tech/topics/security.md>)

Tags: [article](<https://devfeed.tech/tags/article.md>), [backends](<https://devfeed.tech/tags/backends.md>), [community](<https://devfeed.tech/tags/community.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [databases](<https://devfeed.tech/tags/databases.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [release](<https://devfeed.tech/tags/release.md>), [security](<https://devfeed.tech/tags/security.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article announces Neon's support for PgBouncer 1.22.0 and explains prepared statements in Postgres. It covers their potential performance benefits, protection against SQL injection, and the role of PgBouncer connection pooling in reducing the number of active backend processes created by numerous client connections.

## Source excerpt

We're happy to announce Neon's support for PgBouncer 1.22.0. This latest release increases query throughput by 15% to 250% and includes support for DEALLOCATE ALL and DISCARD ALL, as well as protocol-level prepared statements released in 1.21.0. In this article, we'll explore wha...