PostgreSQL各个版本的性能
来源:互联网 发布:兰大网络继续教育学院 编辑:程序博客网 时间:2024/06/08 10:43
基本结论: PostgreSQL性能, 从7.4分到9.4, 提升近8倍. 9.3 and 9.4 give almost the same performance as 9.2 in this particular test, so only 9.2 is on the chart.
另外,这篇文章中值得注意的有:
Scale
In short, scale determines size of the database as a number of rows in the main "accounts" table - the supplied value gets multiplied by 100.000 and that's how many rows in that table you get. This of course determines the size on disk, as every 100.000 rows corresponds to 15MB on disk (including indexes etc.).
When choosing the scale for your benchmark, you have three basic choices, each testing something slightly different.
small
usually scale between 1-10 (15-150MB databases)
only a small fraction of RAM (assuming regular hardware)
usually exposes locking contention, problems with CPU caches and similar issues not visible with larger scales (where it gets overshadowed by other kinds of overhead - most often I/O)
medium
scales corresponding to ~50% of RAM (e.g. 200-300 on systems with 8GB RAM)
the database fits into RAM (assuming there's enough free memory for queries)
often exposes issues with CPU utilization (especially on read-only workloads) or locking
large
scales corresponding to ~200% of RAM, or more (so 1000 on systems with 8GB RAM)
the database does not fit into RAM, so both modes (read-only and read-write) hit the I/O subsystem
exposes issues with inefficient disk access (e.g. because of missing index) and I/O bottlenecks
- PostgreSQL各个版本的性能
- poi的各个版本
- STL 的各个版本
- 火狐的各个版本
- Firefox各个系统的各个版本
- 各个版本的Hello World
- Struts 各个版本的源代码
- Zigbee各个版本的区别
- Modelsim的各个版本_PE_DE_SE
- win8各个版本的区别
- Eclipse各个版本的区别
- spring各个版本的意思
- eclipse各个版本的区别
- Eclipse各个版本的代号
- Framework各个版本的变化
- 各个版本的iphone QQ
- eclipse 各个版本的比较
- 认识linux的各个版本
- Java二十四中设计模式 之 状态模式
- MySQL连接算法的问答辨析并与Oracle简单对比
- MYSQL,临时表优化一例
- MySQL,表连接的一些问题答疑
- qt5.8编译mysql
- PostgreSQL各个版本的性能
- c++第二次作业-定期存款利息计算器
- MySQL单表多索引上分组操作的执行计划分析
- 进程创建时共享内存处理
- MySQL---聚集函数的优化详解
- 数据库缓存区相关的几个问题辨析
- MySQL物理优化---调整优化器代价参数进行优化
- gflags 工具使用小记
- MySQL查询优化技术的一点儿问答