2

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

Abhishek Parikh
  • 21
  • 1
  • 1
  • 2

2 Answers2

3

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

Josh Berkus
  • 1,206
  • 8
  • 6
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

Cargo23
  • 249
  • 1
  • 4
  • 1
    good point, apart from 8.2 being a bit outdated. – András Váczi Jul 12 '12 at 15:41
  • Oh, I didn't even see that was the version that came up in Google. The text is the same even in the current 9.3 dev version: http://www.postgresql.org/docs/devel/static/connect-estab.html – Cargo23 Jul 12 '12 at 15:54