uuid与serial 在TDSQL PG中性能对比

• uuid插入1万条数据。

postgres=#  \d+ t_uuid 
                                             Table "public.t_uuid"
 Column |          Type          |              Modifiers              | Storage  | Stats target | Description 
--------+------------------------+-------------------------------------+----------+--------------+-------------
 f1     | uuid                   | not null default uuid_generate_v1() | plain    |              | 
 f2     | character varying(256) |                                     | extended |              | 
Has OIDs: no
Distribute By SHARD(f2)
        Location Nodes: ALL DATANODES

postgres=# insert into t_uuid(f2) select t from generate_series(1,1000000) as t;
INSERT 0 1000000
Time: 4869.140 ms (00:04.869) 

• serial插入1万条数据。

postgres=# \d+ t_serial
                                                     Table "public.t_serial"
 Column |          Type          |                       Modifiers                       | Storage  | Stats target | Description 
--------+------------------------+-------------------------------------------------------+----------+--------------+-------------
 f1     | integer                | not null default nextval('t_serial_f1_seq'::regclass) | plain    |              | 
 f2     | character varying(256) |                                                       | extended |              | 
Has OIDs: no
Distribute By SHARD(f1)
        Location Nodes: ALL DATANODES

postgres=#  insert into t_serial(f2) select t from generate_series(1,1000000) as t;      
INSERT 0 1000000
Time: 3683.533 ms (00:03.684)

• uuid pgbench结果。

pghost: 172.16.0.42 pgport: 11016 nclients: 32 duration: 600 dbName: postgres
transaction type: insert_t_uuid.sql
scaling factor: 1
query mode: prepared
number of clients: 32
number of threads: 1
duration: 600 s
number of transactions actually processed: 531667
latency average = 36.166 ms
tps = 884.807291 (including connections establishing)
tps = 884.813103 (excluding connections establishing)
script statistics:
 - statement latencies in milliseconds:
         0.013  \set id random(1, 10000000)
        36.094  insert into t_uuid(f2) values(:id::text) ;

• erial pgbench结果。

transaction type: insert_t_serial.sql
scaling factor: 1
query mode: prepared
number of clients: 32
number of threads: 1
duration: 600 s
number of transactions actually processed: 493799
latency average = 38.889 ms
tps = 822.864578 (including connections establishing)
tps = 822.869984 (excluding connections establishing)
script statistics:
 - statement latencies in milliseconds:
         0.013  \set id random(1, 10000000)
        38.861  insert into t_serial(f2) values(:id::text) ;

• 测试数据对比 。