Speed up Postgres queries by 30%: How to use transaction pooling with prepared statements
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
In E73 of “5mins of Postgres” we're talking about how to use transaction pooling with prepared statements to make Postgres up to 30% faster. We're looking at improvements to pgbouncer, PgCat, and other connection poolers.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
Making Postgres 30 Percent Faster in Production - by Lev Kokotov
https://postgresml.org/blog/making-po...
PgCat
https://github.com/postgresml/pgcat
PR for PgCat that added support for prepared statements
https://github.com/postgresml/pgcat/p...
Postgres connection pooling: Comparing PgCat and pgbouncer - 5mins of Postgres E60
https://pganalyze.com/blog/5mins-post...
Yet Another Server Side Prepared Statements Patch - pgbouncer Patch
https://github.com/pgbouncer/pgbounce...
Re: Deleting prepared statements from libpq. - Jelte Fennema
https://www.postgresql.org/message-id...
Support of prepared statements - pgbouncer patch
https://github.com/pgbouncer/pgbounce...