Is there any way to do queries in postgis using multiple cores in a transparent way, other than splitting my queries among several client connections ?
closed as off-topic by Devdatta Tengshe, PolyGeo♦, Fezter♦, Ian Turton♦ Nov 13 '13 at 10:47
- This question does not appear to be about geographic information systems (GIS) within the scope defined in the help center.
The quick answer is that you can't do parallel queries. Not yet, at least.
PostgreSQL, the most common database engine that processes PostGIS queries, has parallel query execution as a development priority. Although there has been some progress on the prerequisite background worker API in versions 9.3 and 9.4, the timing of this feature is probably not expected for at least a year or more.
pgpool-II is a middleware that offers parallel query, although I'm not sure if or how it can be configured for PostGIS.