Gpcopy is taking long time to copy small tables

Products

• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire
• VMware Tanzu Data Suite

Issue/Introduction

Using gpcopy, smaller tables will take hours while larger tables will go much more quickly and without issue.

Environment

gpcopy

Resolution

According to the documentation  Tanzu Greenplum Data Copy Utility 2.4   "For smaller tables, copying tables using the Greenplum Database master is more efficient than using segment instances."

This is a known technical limitation that can be avoided by running another gpcopy concurrently that will focus specifically on the smaller tables to prevent them from causing this inefficiency.