openGauss每日一练第21天 | 存储模型-行存和列存

1. 创建行存表和列存表，并批量插入10万条数据(行存表和列存表数据相同)

需要自己建表！！

create table test_t1 (id int4, name varchar2(20), addr text);
create table test_t2 (id int4, name varchar2(20), addr text) WITH (ORIENTATION = COLUMN);

insert into test_t1 select r, r||'_name', r||'_addr' from generate_series(1,1000000) r;
insert into test_t2 select * from test_t1;

2. 对比行存表和列存表空间大小

\d+

3. 对比查询一列和插入一行的速度

select * from test_t1 where id=50000;
select * from test_t2 where id=50000;

insert into test_t1 values (1000001, '1000001_name', '1000001_addr');
insert into test_t2 values (1000001, '1000001_name', '1000001_addr');

4. 清理数据

drop table test_t1;
drop table test_t2;