How Do I Check Whether a GaussDB(DWS) Table Is Row-Stored or Column-Stored?

The storage mode of a table is controlled by the ORIENTATION parameter in the table creation statement. row indicates row storage, and column indicates column storage.

You can use the table definition function PG_GET_TABLEDEF to check whether the created table is row-store or column-store.

For example, orientation=column indicates a column-store table.

Currently, you cannot run the ALTER TABLE statement to modify the parameter ORIENTATION.

SELECT * FROM PG_GET_TABLEDEF('customer_t1');
                                  pg_get_tabledef                                  
-----------------------------------------------------------------------------------
 SET search_path = tpchobs;                                                       +
 CREATE  TABLE customer_t1 (                                                      +
         c_customer_sk integer,                                                   +
         c_customer_id character(5),                                              +
         c_first_name character(6),                                               +
         c_last_name character(8)                                                 +
 )                                                                                +
 WITH (orientation=column, compression=middle, colversion=2.0, enable_delta=false)+
 DISTRIBUTE BY HASH(c_last_name)                                                  +
 TO GROUP group_version1;
(1 row)

Parent topic: Database Use

Предыдущая статья

How Do I Replace the Null Results with 0 in a GaussDB(DWS) Join Query?

Следующая статья

How Do I Query GaussDB(DWS) Column-Store Table Information?

Была ли эта статья полезна?

Поддержка Юридические документы