How to configure postgresql to use multiple cores?
PostgreSQL automatically uses multiple cores to support multiple database connections, if you have multiple cores.  No further configuration is necessary.