检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Default value: off acceleration_with_compute_pool Parameter description: Specifies whether to use the computing resource pool for acceleration when OBS is queried.
Excellent query performance High-quality query plans and efficient execution engines Precise load management methods Real-Time Write DWS 3.0 utilizes the H-Store storage engine to store micro-batch data locally and syncs it to OBS at regular intervals.
pg_total_relation_size can specify the OID or name of a table or compressed table, and then return the data in bytes and the sizes of all related indexes and compressed tables. pg_obs_file_size(regclass) Description: This function obtains the CU file size, file name, and bucket ID stored on OBS
Use cstore_buffers to specify the cache of ORC, Parquet, or CarbonData metadata and data for OBS or HDFS foreign tables. The metadata cache size should be 1/4 of cstore_buffers and not exceed 2 GB.
Backup Device Select OBS or NFS from the drop-down list. NFS Backup File System Address (NFS) NFS shared IP address. Enter the IP address of the SFS shared path.
Data masking policies can be created for regular tables and non-EXTERNAL-SCHEMA foreign tables (such as OBS, HDFS, GDS, and foreign tables for coordinated analysis), but not for system catalogs, EXTERNAL SCHEMA foreign tables, temporary tables, UNLOGGED tables, views, or functions
Use the default OBS tablespace.
Multi-temperature tables support only partitioned column-store tables and depend on available OBS tablespaces. Multi-temperature tables support only the default tablespace default_obs_tbs. If you need to add an OBS tablespace, contact technical support.
If the manual snapshots are still retained after the cluster is deleted and the total snapshot size exceeds the free space, the excess part will be billed based on the OBS billing rate.
The cold_tablespace and storage_policy parameters of ALTER RESET cannot be used in OBS multi-temperature tables, and COLVERSION cannot be changed to 1.0 for such tables. You can change a column-store table whose COLVERSION parameter is 2.0 to an OBS multi-temperature table.
cluster_id String Cluster ID count Integer Total number Table 3 AuditDumpRecord Parameter Type Description cluster_id String Cluster ID exector_time String Execution time begin_time String Start time end_time String End time bucket_name String Bucket name location_prefix String OBS
- Cold Data Store data in separate OBS buckets, which are billed on a pay-per-use basis. - Nodes Specify the number of nodes in the cluster. The number of nodes ranges from 3 to 256. 3 Total Display the cluster's total capacity.
The cold_tablespace and storage_policy parameters of ALTER RESET cannot be used in OBS multi-temperature tables, and COLVERSION cannot be changed to 1.0 for such tables. You can change a column-store table whose COLVERSION parameter is 2.0 to an OBS multi-temperature table.
* 2,3,4,5,6,7", "backup_type": "increment", "backup_level": "cluster", "next_fire_time": "1667213760000", "update_time": "2022-10-31T02:54:54" } ], "device_name": "obs", "server_ips": null, "server_port": null, "backup_param": "" } SDK Sample
Snapshots are stored in the storage space of Object Storage Service (OBS). snapshot restoration A snapshot can be used to restore a cluster to a newly created one that has the same specifications. Currently, you can restore a cluster only to a new one.
Currently, you can use ANALYZE to collect statistics about row-store tables, column-store tables, HDFS tables, ORC- or CARBONDATA-formatted OBS foreign tables, and foreign tables for collaborative analysis.
For OBS multi-temperature tables: The tablespace of a partitioned table cannot be set to an OBS tablespace during the MOVE, EXCHANGE, MERGE, and SPLIT operations.
Type: USERSET Value range: enumerated values 0: The size of the database is directly estimated based on the OBS bucket. 1: The size of the entire database is normally calculated in regular mode.
Use cstore_buffers to specify the cache of ORC, Parquet, or CarbonData metadata and data for OBS or HDFS foreign tables. The metadata cache size should be 1/4 of cstore_buffers and not exceed 2 GB.
status String Status of the DR cluster restoring: DCS instance restoration is in progress. stopped: The task has been stopped. waiting: The task is being executed in the next period. abnormal progress String DR progress last_success_time String Last DR time obs_bucket_name String OBS