latency Archives - 2ndQuadrant

Posts

Local Persistent Volumes and PostgreSQL usage in Kubernetes

June 22, 2020/1 Comment/in 2ndQuadrant, Cloud Native /by Gabriele Bartolini

Can I use PostgreSQL in Kubernetes and expect to achieve performance results of the storage that are comparable to traditional installations on bare metal or VMs? In this article I go through the benchmarks we did in our own Private Cloud based on Kubernetes 1.17 to test the performance of local persistent volumes using OpenEBS […]

PG Phriday: BDR Around the Globe

May 4, 2018/2 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

With the addition of logical replication in Postgres 10, it’s natural to ask “what’s next”? Though not directly supported yet, would it be possible to subscribe two Postgres 10 nodes to each other? What kind of future would that be, and what kind of scenarios would be ideal for such an arrangement? As it turns […]

PostgreSQL-based application performance: latency and hidden delays

May 23, 2016/2 Comments/in Craig's PlanetPostgreSQL, PostgreSQL /by craig.ringer

If you’re trying to optimise the performance of your PostgreSQL-based application you’re probably focusing on the usual tools: EXPLAIN (BUFFERS, ANALYZE), pg_stat_statements, auto_explain, log_statement_min_duration, etc. Maybe you’re looking into lock contention with log_lock_waits, monitoring your checkpoint performance, etc too. But did you think about network latency? Gamers know about network latency, but did you think […]

Posts

Support & Services

Products

Postgres Learning Center

About Us