Start Now

Tag: Latency

Client-Side vs Server-Side Latencies Demystified in PostgreSQL and YugabyteDB

Client-Side vs Server-Side Latencies Demystified in PostgreSQL and YugabyteDB

Every SQL execution in PostgreSQL and therefore in YugabyteDB YSQL takes time to process. A common way to identify how much is time spent on processing is to use the pg_stat_statements view in the database. However, the time visible in pg_stat_statements might differ from the time a database client registers for the execution. Where does this difference come from? Let’s take a look.

Read more

Geo-Distribution in YugabyteDB: Engineering Around the Physics of Latency

Geo-Distribution in YugabyteDB: Engineering Around the Physics of Latency

Customers today expect always-on, highly responsive access to services wherever they are in the world. This is driving businesses to deploy globally distributed applications that deliver better customer experiences. Moving to a geo-distributed database is a key part of this. Moving data closer to where the end-users are enables lower latency access. Geo-distribution can make the data service resilient to zone and region failures in the cloud. Recent adverse weather conditions and data center accidents have underscored the need for this.

Read more

Reads in YugabyteDB – Tuning Consistency, Latency and Fault Tolerance

Reads in YugabyteDB – Tuning Consistency, Latency and Fault Tolerance

Introduction

YugabyteDB is built primarily to be a CP database per the CAP theorem. It supports two interfaces – YSQL for SQL workloads and YCQL for Cassandra-like workloads. In this blog, we will primarily talk about the YCQL interface. When an application interacts with the database using the YCQL interface, the writes are always consistent and reads are consistent by default. When this level of consistency is not required, YugabyteDB supports two other types of reads:

1.

Read more

Learn More to Accelerate Your Retail Business

Ready to dive deeper into distributed SQL, YugabyteDB, and Yugabyte Cloud?
Learn at Yugabyte University
Learn More
Browse Yugabyte Docs
Read More
Join the Yugabyte Community
Join Now