MySpace

转载▼GP支持分区表，主要用来存放大表，如fact table目的：1. 把大数据切片,便于查询2. 便于数据库维护分区创建时，每个分区会自带一个Check约束，来限定数据的范围。Check约束也用于 执行查询时定位分区。支持分区类型：1. 范围分区 range partition2. 列表分区 list partition3.

HowTo - Creating a read-only user in GPDBProblemHow do i create a read-only user ? The user ( non-superuser ) with connect permission on the database is able to create / drop object on the d

Script - Table distribution policy information (via Unix Shell Script)GoalIs to provide a simple shell scripts to help administrator identify the distribution policy of the tables in the d