...
Although specifying exact postgresql.conf configuration parameters may seem beneficial, in reality, every installation is different. There are many factors in tuning your cluster including system memory, resource contention from other services running on the server, available disk space, disk types et al. The primary cluster supporting your updates was tuned using the tool pgtune. It is recommended to run the tool and apply the changes before bulk loading the data. Note that this requires Python.
| Code Block | ||
|---|---|---|
| ||
yum install pgtune pgtune -i postgresql.conf -T DW -c 500 [ paste added configuration options at end of postgres.conf ] |
...
If desired, you can redirect errors (if any) to LOG.2:
| Code Block | ||
|---|---|---|
| ||
cat alexandria-dwh.sql | psql -Ualexandria postgres 2>LOG.2 |
...