表的记录数: 1578463
select count(*) from reorder_guideline;
count
1578463 (1 行记录)
2. 三种创建表的语句Create Table:
(1) 最常用的 (23171.485ms)
a1stream_db=> create table reorder_guideline_2 as table reorder_guideline;
时间:23171.485 ms
(2) 带Unlogged 标识的 (1734.085ms)
create UNLOGGED table reorder_guideline_2 as table reorder_guideli
ne;
时间:1734.085 ms
(3) 带TEMP 标识的临时表(1666.934ms)
create temp table reorder_guideline_2 as table reorder_guideline;
时间:1666.934 ms