How can I configure postgresql to use multiple cores in a single machine , is it automatically uses it ?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
PostgreSQL automatically uses multiple cores to support multiple database connections, if you have multiple cores. No further configuration is necessary.
Postgres allocates one process per client, and, generally speaking you will only see that process go to 100% of 1 of your cores. To increase throughput you need to use more clients/connections.