5mins of Postgres E32: Benchmark and improve query network latency using tc, COPY and pipeline mode
Today, we're gonna talk about network latency, how it impacts your query performance and how to improve it by using pipeline mode or COPY in Postgres. We also take a look at traffic control with the Linux tc tool.
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:
Adding latency: one step, two step, oops - by Lawrence Jones
https://blog.lawrencejones.dev/latency/
Lawrence Jones on Twitter
/ lawrjones
Linux traffic control
https://en.wikipedia.org/wiki/Tc_(Linux)
How to use \timing in postgres
https://stackoverflow.com/questions/4...
What does \timing measure? - PostgreSQL mailing list thread
https://www.postgresql.org/message-id...
How does COPY work and why is it so much faster than INSERT?
https://stackoverflow.com/questions/4...
Pipeline mode on postgresql.org
https://www.postgresql.org/docs/curre...