Skip site navigation (1) Skip section navigation (2)

Re: Parallel query execution

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>,Josh Berkus <josh(at)agliodbs(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Parallel query execution
Date: 2013-01-16 17:13:51
Message-ID: 20130116171351.GB1099@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Jan 16, 2013 at 01:48:29AM -0300, Alvaro Herrera wrote:
> 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(at)agliodbs(dot)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.

Wow, I had no idea we were that far behind.  I have avoided commit-fest
work because I often travel so might leave the items abandoned, and I
try to do cleanup of items that never make the commit-fest --- I thought
that was something that needed doing too, and I rarely can complete that
task.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2013-01-16 17:16:27
Subject: Re: Parallel query execution
Previous:From: Bruce MomjianDate: 2013-01-16 17:11:42
Subject: Re: Parallel query execution

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group