................................................................................ - 265 - CPU 主频与 Core 数量 .......................................................................................... - 265 gp_session_role=utility' psql 在 GP 推荐的硬件配置环境下，每个 Instance 需要对应数个 CPU Core 的资源 资源，具体的比例需要根据数据库的适用场景进行综合评估。例如在生产环境，每个 Instance 所在的主机配置了 2 个 16 Core 的 CPU，可根据不同的场景，配置 4 ~ 12 个不等的 Primary，这个数字的选择需要由富有经验的专业技术支持人员进行评估， 下表列举了资源队列和资源组之间的差异： 功能点 资源队列 资源组 并发 查询语句级别的控制 事务级别的控制 CPU 指定查询的优先级 指定 CPU 资源的百分比或 CPU Core 限制 内存 在资源队列中控制，允许超过限制 在事务级别控制，更精准，不允许超过限制 内存隔离 无 在资源组之间隔离，在同一资源组内的不同 事务之间隔离 用户 资源配额仅对非管理员用户有效

上海安吉物流：收入&市场分析、客户经理跟踪分析 • 中远集团：收入、发展、销售分析 案例分享（征途游戏） • 现有运行平台 – 服务器平台：SUN X4600一台，4路dual-core CPU 共8core，32GB – 存储平台：NetApp一台 – 网络平台：千兆网络 – 软件平台：RedHat linux + mysql – 应用软件：基于Apache的PHP程序 • 现有运行现状 的数据累加，到11月份月度数据处理时，该应用耗时达到65小时。 • 测试运行平台 – 服务器平台：SUN X4500两台，每台含2路dual-core CPU 共4core， 16GB；SUN X4200一台，2路dual-core CPU 共4core，8GB – 存储平台：每台X4500中各48块500GB硬盘，共96 * 500GB – 网络平台：每台X4500和X4200上各有4块千兆网卡 all processing as close as possible to the data • Fully parallel execution tuned for modern multi-core CPUs • High bandwidth efficient I/O to local DAS or FC connected storage Local compute Local storage

Inc 9 Changed Features 227 Resolved Issues 228 Release 6.0.0 229 New Features 230 PostgreSQL Core Features 230 INTERVAL Data Type Handling 230 Additional PostgreSQL Features 231 Zstandard Compression Parameters Settings 397 The hosts File 398 The sysctl.conf File 398 System Resources Limits 401 Core Dump 401 XFS Mount Options 401 Disk I/O Settings 402 Networking 404 Transparent Huge Pages (THP) Memory Auditor 1136 Transaction Concurrency Limit 1137 CPU Limits 1137 Assigning CPU Resources by Core 1138 Assigning CPU Resources by Percentage 1139 Elastic mode 1139 Ceiling Enforcement mode 1140

1 234 Changed Features 235 Resolved Issues 235 Release 6.0.0 237 New Features 237 PostgreSQL Core Features 237 INTERVAL Data Type Handling 237 Additional PostgreSQL Features 238 Zstandard Compression Parameters Settings 410 The hosts File 411 The sysctl.conf File 411 System Resources Limits 414 Core Dump 414 XFS Mount Options 415 Disk I/O Settings 415 Networking 417 Transparent Huge Pages (THP) Memory Auditor 1173 Transaction Concurrency Limit 1174 CPU Limits 1174 Assigning CPU Resources by Core 1175 Assigning CPU Resources by Percentage 1176 Elastic mode 1176 Ceiling Enforcement mode 1176

1 224 Changed Features 224 Resolved Issues 224 Release 6.0.0 226 New Features 226 PostgreSQL Core Features 227 INTERVAL Data Type Handling 227 Additional PostgreSQL Features 227 Zstandard Compression Parameters Settings 394 The hosts File 395 The sysctl.conf File 395 System Resources Limits 398 Core Dump 398 XFS Mount Options 398 Disk I/O Settings 399 Networking 401 Transparent Huge Pages (THP) Memory Auditor 1132 Transaction Concurrency Limit 1132 CPU Limits 1133 Assigning CPU Resources by Core 1133 Assigning CPU Resources by Percentage 1134 Elastic mode 1135 Ceiling Enforcement mode 1135

1 266 Changed Features 267 Resolved Issues 267 Release 6.0.0 269 New Features 269 PostgreSQL Core Features 269 INTERVAL Data Type Handling 269 Additional PostgreSQL Features 270 Zstandard Compression Parameters Settings 402 The hosts File 403 The sysctl.conf File 403 System Resources Limits 406 Core Dump 407 XFS Mount Options 407 Disk I/O Settings 407 Networking 410 Transparent Huge Pages (THP) Memory Auditor 1188 Transaction Concurrency Limit 1189 CPU Limits 1189 Assigning CPU Resources by Core 1190 Assigning CPU Resources by Percentage 1191 Elastic mode 1191 Ceiling Enforcement mode 1191

1 203 Changed Features 203 Resolved Issues 204 Release 6.0.0 205 New Features 205 PostgreSQL Core Features 206 INTERVAL Data Type Handling 206 Additional PostgreSQL Features 206 Zstandard Compression Parameters Settings 334 The hosts File 335 The sysctl.conf File 335 System Resources Limits 337 Core Dump 338 XFS Mount Options 338 Disk I/O Settings 338 Networking 340 Transparent Huge Pages (THP) Documentation VMware, Inc 50 Transaction Concurrency Limit 992 CPU Limits 993 Assigning CPU Resources by Core 993 Assigning CPU Resources by Percentage 994 Elastic mode 995 Ceiling Enforcement mode 995 Memory

1 253 Changed Features 253 Resolved Issues 254 Release 6.0.0 255 New Features 256 PostgreSQL Core Features 256 INTERVAL Data Type Handling 256 Additional PostgreSQL Features 257 Zstandard Compression Parameters Settings 384 The hosts File 385 The sysctl.conf File 385 System Resources Limits 388 Core Dump 389 XFS Mount Options 389 Disk I/O Settings 389 Networking 391 Transparent Huge Pages (THP) Memory Auditor 1156 Transaction Concurrency Limit 1157 CPU Limits 1157 Assigning CPU Resources by Core 1158 Assigning CPU Resources by Percentage 1159 Elastic mode 1160 Ceiling Enforcement mode 1160

1 207 Changed Features 207 Resolved Issues 207 Release 6.0.0 209 New Features 209 PostgreSQL Core Features 209 INTERVAL Data Type Handling 209 Additional PostgreSQL Features 210 Zstandard Compression Parameters Settings 242 The hosts File 243 The sysctl.conf File 243 System Resources Limits 245 Core Dump 246 XFS Mount Options 246 Disk I/O Settings 247 Transparent Huge Pages (THP) 248 IPC Object Memory Auditor 1010 Transaction Concurrency Limit 1011 CPU Limits 1011 Assigning CPU Resources by Core 1012 Assigning CPU Resources by Percentage 1013 Elastic mode 1013 Ceiling Enforcement mode 1013

1 215 Changed Features 215 Resolved Issues 215 Release 6.0.0 216 New Features 217 PostgreSQL Core Features 217 INTERVAL Data Type Handling 217 Additional PostgreSQL Features 218 Zstandard Compression Parameters Settings 249 The hosts File 250 The sysctl.conf File 250 System Resources Limits 252 Core Dump 253 XFS Mount Options 253 Disk I/O Settings 254 Transparent Huge Pages (THP) 255 IPC Object Memory Auditor 1019 Transaction Concurrency Limit 1020 CPU Limits 1020 Assigning CPU Resources by Core 1021 Assigning CPU Resources by Percentage 1022 Elastic mode 1022 Ceiling Enforcement mode 1022