Configure System settings
Database systems like Apache Cloudberry require specific system resource limits to operate efficiently. These limits should be configured for the gpadmin
user who runs the database processes.
-
Create resource limits configuration
Create user limits configuration file:
sudo tee /etc/security/limits.d/90-db-limits.conf << 'EOF'
# Core dump file size limits for gpadmin
gpadmin soft core unlimited
gpadmin hard core unlimited
# Open file limits for gpadmin
gpadmin soft nofile 524288
gpadmin hard nofile 524288
# Process limits for gpadmin
gpadmin soft nproc 131072
gpadmin hard nproc 131072
EOF -
Understand the limits.
The configuration sets the following types of resource limits:
-
Core Dumps (
core
):- Set to
unlimited
to enable complete core dumps - Essential for debugging and troubleshooting
- Both soft and hard limits are unrestricted
- Set to
-
Open Files (
nofile
):- Set to
524288
(512K) files - Required for handling many concurrent database connections
- Critical for distributed operations and large workloads
- Set to
-
Process Limits (
nproc
):- Set to
131072
(128K) processes - Enables parallel query execution
- Supports Cloudberry's distributed architecture
- Set to
-
-
Verify resource limits.
# Check current limits
sudo -u gpadmin bash -c "ulimit -a"