Re: Parallel query execution - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Parallel query execution
Date
Msg-id 20130116044829.GJ4146@alvh.no-ip.org
Whole thread Raw
In response to Re: Parallel query execution  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Parallel query execution
Re: Parallel query execution
List pgsql-hackers
Bruce Momjian escribió:
> On Wed, Jan 16, 2013 at 01:28:18PM +0900, Michael Paquier wrote:
> >
> >
> > On Wed, Jan 16, 2013 at 1:22 PM, Josh Berkus <josh@agliodbs.com> wrote:
> >
> >     Claudio, Stephen,
> >
> >     It really seems like the areas where we could get the most "bang for the
> >     buck" in parallelism would be:
> >
> >     1. Parallel sort
> >     2. Parallel aggregation (for commutative aggregates)
> >     3. Parallel nested loop join (especially for expression joins, like GIS)
> >
> > parallel data load? :/
>
> We have that in pg_restore, and I thinnk we are getting parallel dump in
> 9.3, right?  Unfortunately, I don't see it in the last 9.3 commit-fest.
> Is it still being worked on?

It's in the previous-to-last commitfest.  IIRC that patch required
review and testing from people with some Windows background.

There are still 34 items needing attention in CF3.  I suggest that, if
you have some spare time, your help would be very much appreciated
there.  The commitfest that started on Jan 15th has 65 extra items.
Anything currently listed in CF3 can rightfully be considered to be part
of CF4, too.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Parallel query execution
Next
From: Josh Kupershmidt
Date:
Subject: Re: string escaping in tutorial/syscat.source