Re: partition query on multiple cores - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: partition query on multiple cores
Date
Msg-id 4DC98AAB.10005@fuzzy.cz
Whole thread Raw
In response to Re: partition query on multiple cores  (Shaun Thomas <sthomas@peak6.com>)
Responses Re: partition query on multiple cores  (Mason S <masonlists@gmail.com>)
List pgsql-performance
Dne 10.5.2011 18:22, Shaun Thomas napsal(a):
> On 05/10/2011 10:06 AM, Maciek Sakrejda wrote:
>
>>> I have 8-core server, I wanted to ask whether a query can be divided for
>>> multiple processors or cores, if it could be what to do in postgresql
>>
>> No, at this time (and for the foreseeable future), a single query will
>> run on a single core.
>
> It can *kinda* be done. Take a look at GridSQL.

Or pgpool-II, that can give you something similar.

http://pgpool.projects.postgresql.org/

regards
Tomas

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: help speeding up a query in postgres 8.4.5
Next
From: "Pierre C"
Date:
Subject: Postgres NoSQL emulation