5mins of Postgres E36: Optimizing query throughput in Python using pipeline mode and psycopg 3.1
Today, we're going to talk about the new psycopg driver for Python. We're also going to talk about pipeline mode in psycopg and how it works.
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
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:
Psycopg 3.1 released - by Daniele Varrazzo
https://www.psycopg.org/articles/2022...
Daniele Varrazzo on GitHub
https://github.com/dvarrazzo
psycopg on Twitter
/ psycopg
Pipeline mode in Psycopg - by Denis Laxalde
https://blog.dalibo.com/2022/09/19/ps...
Denis Laxalde on GitHub
https://github.com/dlax
5mins of Postgres E32: Benchmarking and improving query network latency using tc, COPY and pipeline mode
https://pganalyze.com/blog/5mins-post...
PQtrace on the postgresql.org documentation
https://www.postgresql.org/docs/14/li...
pganalyze eBook: Best Practices for Optimizing Postgres Query Performance
https://pganalyze.com/ebooks/optimizi...