Home / Companies / Yugabyte / Blog / Post Details
Content Deep Dive

Getting Started with pgbench and Distributed SQL on GKE

Blog post from Yugabyte

Post Details
Company
Date Published
Author
Jimmy Guerrero
Word Count
1,878
Language
English
Hacker News Points
-
Summary

The text discusses the use of `pgbench`, a simple program for running benchmark tests on PostgreSQL, to compare its performance with that of YugabyteDB, an open-source, high-performance distributed SQL database. The authors have forked `pgbench` and renamed it to `ysql_bench` to run against YugabyteDB, which is PostgreSQL wire compatible. The tutorial guides the reader through setting up a Kubernetes cluster on Google Cloud Platform (GCP) and deploying YugabyteDB using Helm charts. It then walks through initializing and running `ysql_bench` against the YugabyteDB cluster, providing an overview of its usage and configuration options. The authors highlight that while `pgbench` is designed for single-node PostgreSQL deployments, it can still be used to benchmark distributed SQL databases like YugabyteDB, offering valuable insights into cluster sizing, deployment architecture, and resource allocation.