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

Re: Parallel query execution

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Parallel query execution
Date: 2013-01-15 22:45:15
Message-ID: 20130115224515.GJ27934@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Jan 15, 2013 at 10:39:10PM +0000, Peter Geoghegan wrote:
> On 15 January 2013 22:14, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > I believe it is time to start adding parallel execution to the backend.
> > We already have some parallelism in the backend:
> > effective_io_concurrency and helper processes.  I think it is time we
> > start to consider additional options.
> 
> A few months back, I remarked [1] that speeding up sorting using
> pipelining and asynchronous I/O was probably parallelism low-hanging
> fruit. That hasn't changed, though I personally still don't have the
> bandwidth to look into it in a serious way.
> 
> [1] http://www.postgresql.org/message-id/CAEYLb_VeZpKDX54VEx3X30oy_UOTh89XoejJW6aucjjiUjskXw@mail.gmail.com

OK, I added the link to the wiki.

-- 
  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: Andrew DunstanDate: 2013-01-15 22:45:46
Subject: Re: json api WIP patch
Previous:From: Peter GeogheganDate: 2013-01-15 22:39:10
Subject: Re: Parallel query execution

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