2

How can I configure postgresql to use multiple cores in a single machine , is it automatically uses it ?

2
2

PostgreSQL automatically uses multiple cores to support multiple database connections, if you have multiple cores. No further configuration is necessary.

2

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.

http://www.postgresql.org/docs/8.2/static/connect-estab.html

2

Not the answer you're looking for? Browse other questions tagged or ask your own question.