http://200yi.com/ff_internal/ 2026-04-28T01:16:49+0800 http://200yi.com/ff_internal/ http://200yi.com/ff_internal/lib/tpl/mnml-blog/images/favicon.ico text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:%E6%B5%8B%E8%AF%95:Greenplum%206.9%20%E5%88%97%E5%AD%98TPC-H%E6%B5%8B%E8%AF%95%E6%96%B9%E6%B3%95&rev=1687008318&do=diff 本文适用于：GP 6.9 列存TPC-H 1000s测试。 一、建表 DROP TABLE IF EXISTS NATION; DROP TABLE IF EXISTS REGION; DROP TABLE IF EXISTS PART; DROP TABLE IF EXISTS SUPPLIER; DROP TABLE IF EXISTS PARTSUPP; DROP TABLE IF EXISTS CUSTOMER; DROP TABLE IF EXISTS ORDERS; DROP TABLE IF EXISTS LINEITEM; CREATE TABLE NATION( N_NATIONKEY BIGINT NOT NULL, N_NAME CHAR(25) NOT NULL, N_REGIONKEY BIGINT NOT NULL, N_COMMENT VARCHAR(152)) WITH (appendonly=true, orientation=column, compresstype=zlib, compresslevel=5, oids… text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:%E6%B5%8B%E8%AF%95:Greenplum%20TPC-H%E6%B5%8B%E8%AF%95%E4%B8%AD%E9%82%A3%E4%BA%9B%E5%9D%91&rev=1687008318&do=diff 一、测试环境 项目 值 ---------------------- ------------------------------------ Greenplum Database版本 6.9.0 数据量 TPC-H 1000s _