O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using sample data sets

There are enough sample data sets that are available for PostgreSQL, and most of the data sets are implemented by considering real-time business cases.

Note

Find the list of sample data sets that are available for postgres at this URL: https://wiki.postgresql.org/wiki/Sample_Databases.

Benchmarking tools such as pgBench and BenchmarkSQL will initiate a sample data set, on which they generate a real-time database load and do the benchmarking. In this chapter, to demonstrate a few aspects of the optimizer, let's choose the BenchmarkSQL's catalog tables, which will generate enough data load for this chapter's demonstrations.

Getting ready

BenchmarkSQL is an open source implementation of the popular TPC/C OLTP database benchmark, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required