On Tue, May 10, 2011 at 2:57 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
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.
Last time I tested parallelism in pgpool-II, I saw that if your query is fairly simple, pgpool-II will help. If it is more complex with joins and aggregates, GridSQL will typically outperform it. GridSQL pushes down joins as much as possible, minimizes row shipping, and parallelizes aggregates and grouping.