PowerCenter
- PowerCenter 10.5.5
- All Products
Parameter
| Minimum Value
| Recommended Value
|
---|---|---|
max_connections
| 200
| 4000
|
shared_buffers
| 2 GB
| 16 GB
|
max_locks_per_transaction
| 1024
| 4000
|
max_wal_size
| 1 GB
| 8 GB
|
checkpoint_timeout
| 5 minutes
| 30 minutes
|
Ensure that the entries for the [PCRS_DB_SERVICE_NAME] entry match the configuration for the PowerCenter Repository Service. To securely connect to PostgreSQL for the PowerCenter repository, set the security property along with the remaining required database properties in the pg_service.conf file in the following format:[PCRS_DB_SERVICE_NAME] host=Database host IP port=Database port dbname=PowerCenter repository database service name
$ export PGSERVICEFILE; PGSERVICEFILE=<pg_service.conf file directory>/pg_service.conf
$ setenv PGSERVICEFILE <pg_service.conf file directory>/pg_service.conf