Skip to content

Changes

Page history
更新 6.普通表和分区表插入测试 authored by 劉　百万's avatar 劉　百万
Show whitespace changes
Inline Side-by-side
6.普通表和分区表插入测试.md
View page @ 370d95a5
......@@ -74,7 +74,7 @@ tps = 0.329350 (excluding connections establishing)
statement latencies in milliseconds:
3036.281 insert into employee (code, empname,createtime)
```
> **60秒插入1600万数据;**
> **60秒插入2000万数据;**
> **每100万数据平均时间是3036.281;**
......@@ -119,7 +119,7 @@ tps = 0.297423 (excluding connections establishing)
statement latencies in milliseconds:
3362.213 insert into employee_range (code, empname,createtime)
```
> **60秒插入1500万数据;**
> **60秒插入1800万数据;**
> **每100万数据平均时间是3362.213ms**
### 分区表数据查看
......@@ -162,7 +162,7 @@ tps = 0.377753 (excluding connections establishing)
statement latencies in milliseconds:
2647.226 insert into employee (code, empname,createtime)
```
> **60秒插入1600万数据;**
> **60秒插入2300万数据;**
> **每100万数据平均时间是2647.226ms;**
......@@ -207,7 +207,7 @@ tps = 0.353348 (excluding connections establishing)
statement latencies in milliseconds:
2830.070 insert into employee_range (code, empname,createtime)
```
> **60秒插入1500万数据;**
> **60秒插入2200万数据;**
> **每100万数据平均时间是2830.070ms**
### 分区表数据查看
......@@ -249,7 +249,7 @@ tps = 0.408457 (excluding connections establishing)
statement latencies in milliseconds:
2448.236 insert into employee (code, empname,createtime)
```
> **60秒插入1600万数据;**
> **60秒插入2500万数据;**
> **每100万数据平均时间是2448.236ms;**
......@@ -294,8 +294,8 @@ tps = 0.361302 (excluding connections establishing)
statement latencies in milliseconds:
2767.764 insert into employee_range (code, empname,createtime)
```
> **60秒插入1500万数据;**
> **每100万数据平均时间是2830.070ms**
> **60秒插入2300万数据;**
> **每100万数据平均时间是2767.764ms**
### 分区表数据查看
```
......@@ -307,7 +307,7 @@ select *,tableoid::regclass from employee_range where code in (1,250000,500000,7
| | 1核2G(ms) | 2核4G(ms) | 4核8G(ms) | 平均消耗时间(ms) |
| ------ | -------------- | -------------- | -------------- | ------------ |
| 普通表 | 3036.281 | 2647.226 | 2448.236 | 2710.581 |
| 分区表 | 3362.213 | 2830.070 | 2830.070 | 3007.451 |
| 分区表 | 3362.213 | 2830.070 | 2767.764 | 2986.682 |
> **插入分区表比插入普通表慢一些.**