cleverxiao001

explain(verbose) output: QUERY PLAN Gather Motion 36:1 (slice1; segments: 36) (cost=0.00..431.00 rows=1 width=32) " Output: country, ref_year, (count(*)), (count(DISTINCT ref_uid))" -> GroupAggregate (cost=0.00..431.00 rows=1 width=32) " Output: country, ref_year, count(*),...

error log in seg7: 2025-07-25 00:53:59.841934 EDT,"gpadmin","postgres",p268864,th1103079616,"168.160.18.164","59040",2025-07-25 00:53:59 EDT,0,con3,,seg7,,,,sx1,"LOG","00000","statement: select gid from pg_prepared_xacts where prepared < now() - interval'120 seconds'",,,,,,,0,,"postgres.c",1713, 2025-07-25 00:54:11.632398 EDT,,,p268891,th1103079616,"168.160.18.164","23646",2025-07-25 00:54:11 EDT,0,,,seg7,,,,,"LOG","00000","query finish request to process 268743",,,,,,,0,,"postmaster.c",2932,...

All data is imported by using Spark to call the method: copy tableName from stdin with (format csv, NULL '\\N'). I wonder if it has anything to do with the...

The cluster consists of two servers in total. The segments are evenly distributed across the two servers. All hard drives are installed on one of the servers, managed via LVM...