May 2024
Intermediate to advanced
407 pages
6h 11m
Chinese
Content preview from PostgreSQL 9.0性能调校Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
第8章 数据库基准评测
PostgreSQL自带了名为pgbench的基准评测程序，可以进行多种测试。所包含的默认测试都很有用，但也包含了一些数据库基准评测的脚本供用户进行自定义的测试。用户甚至可以使用pgbench核心这样一个有效的可扩展多个客户端的数据库程序来完成完全的自定义测试。尽管在大多数情况下没有经过官方的审核，用户也可以使用一些行业标准的测试方法将PostgreSQL与其他的数据库产品进行比较。
8.1 pgbench默认测试
pgbench测试的最初灵感源于事务处理性能委员会（TPC）的基准评测TPC-B，它的官方页面为：http://www.tpc.org/tpcb/。
TPC最初的版本于1990年（这从现在的TPC角度来看已经明显过时了）开发，其基准评测模型是简单的银行业务程序，包括一些支行，每个支行有一部分职员和账号。
8.1.1 表的定义
在此处添加的一些主要表的SQL如下所示。
PostgreSQL 8.4版本之前，这些表的表名没有包含
pgbench_前缀。这是很危险的，在错误运行 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.