gp加可自增长的列 ALTER TABLE school_info ADD COLUMN dataId serial; select * from school_info where "ID" <100 order by "ID" asc; gp的配置信息 select * from gp_segment_configuration ; gp数据的所有表的信息 select * from pg_
PG/GP排序私有状态结构Tuplesortstate中有一个成员SortSupport sortKeys;而sortKeys中有这么几个成员abbreviate、abbrev***: "abbreviate" concerns whether or not the abbreviated key optimization is applicable in principle。也就是说可以使用