(cloudberry) 02/15: gpexpand.status_detail should be distributed by "table_oid".

[av...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

avamingli pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git

commit 384619e4df5ec47d0a4f1e51e7c1570d93f4e990
Author: Zhenghua Lyu <ka...@gmail.com>
AuthorDate: Mon Jan 9 18:45:19 2023 +0800

    gpexpand.status_detail should be distributed by "table_oid".
    
    The table gpexpand.status_detail used by gpexpand should be
    distributed by "table_oid", to avoid the updating workload burden of
    tens thounsand tables in a segment, concentrated on only one single
    segment with the prior distribution policy (distributed by dbname).
    
    Authored-by: Peng Han <ph...@vmware.com>
---
 gpMgmt/bin/gpexpand | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/gpMgmt/bin/gpexpand b/gpMgmt/bin/gpexpand
index 7f65ce0946..4ab60e1e7c 100755
--- a/gpMgmt/bin/gpexpand
+++ b/gpMgmt/bin/gpexpand
@@ -285,7 +285,7 @@ status_detail_table_sql = """CREATE TABLE gpexpand.status_detail
                           status text,
                           expansion_started timestamp,
                           expansion_finished timestamp,
-                          source_bytes numeric ) """
+                          source_bytes numeric ) distributed by (table_oid)"""
 # gpexpand views
 progress_view_simple_sql = """CREATE VIEW gpexpand.expansion_progress AS
 SELECT


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org