Re: partition query on multiple cores

On Tue, May 10, 2011 at 2:57 PM, Tomas Vondra <tv(at)fuzzy(dot)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.
>
> http://pgpool.projects.postgresql.org/
>
>
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.

Mason Sharp