Hot and Cold Table Functions
pg_obs_cold_refresh_time(table_name, time)
Description: Modifies the time when cold data in a multi-temperature table is migrated to OBS. The default value is 00:00 every day.
table_name indicates the name of the multi-temperature table, and the type is Name. time indicates the time when the data switchover task is scheduled, and the type is Time.
Return value: SUCCESS. The time is successfully modified.
Example:
1 2 3 4 5 |
SELECT * FROM pg_obs_cold_refresh_time('lifecycle_table', '06:30:00'); pg_obs_cold_refresh_time -------------------------- SUCCESS (1 row) |
pg_refresh_storage()
Description: Switches hot data to cold data on all hot and cold tables (in OBS).
Return type: int
Fields in the returned value
- success_count int: indicates the number of tables that are successfully switched.
- failed_count int: indicates the number of tables that fail to be switched.
Example:
1 2 3 4 5 |
SELECT * FROM pg_refresh_storage(); success_count | failed_count ---------------+-------------- 1 | 0 (1 row) |
pg_lifecycle_table_data_distribute(table_name)
Description: Views the data distribution of a cold or hot table.
table_name indicates the table name and cannot be left blank.
Return value: record
Example: Multiple records are generated based on the number of nodes. The following example shows the data distribution in the w1 table when there is only one DN node.
1 2 3 4 5 |
SELECT * FROM pg_catalog.pg_lifecycle_table_data_distribute('w1'); schemaname | tablename | nodename | hotpartition | coldpartition | switchablepartition | hotdatasize | colddatasize | switchabledatasize ------------+-----------+----------+--------------+---------------+---------------------+-------------+--------------+-------------------- public | w1 | dn_1 | p2 | p1 | | 80 KB | 0 bytes | 0 bytes (1 row) |
pg_lifecycle_node_data_distribute()
Description: Views the data distribution of all hot and cold tables.
Return value: record
Example: There are two cold and hot tables in the database. The data distribution is as follows:
1 2 3 4 5 6 |
SELECT * FROM pg_catalog.pg_lifecycle_node_data_distribute(); schemaname | tablename | nodename | hotpartition | coldpartition | switchablepartition | hotdatasize | colddatasize | switchabledatasize ------------+-----------+----------+--------------+---------------+---------------------+-------------+--------------+-------------------- public | w1 | dn_1 | p2 | p1 | | 81920 | 0 | 0 public | w2 | dn_1 | p2 | p1 | | 81920 | 0 | 0 (2 rows) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot