Re: PostgreSQL Parallel Processing ! - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: PostgreSQL Parallel Processing !
Date
Msg-id CAHyXU0zRRWrV5p1U6zAhz=95m3y4Z_9WdYBGwNuKEFX_t1ySnw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Parallel Processing !  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: PostgreSQL Parallel Processing !
List pgsql-performance
On Wed, Jan 25, 2012 at 7:43 AM, Claudio Freire <klaussfreire@gmail.com> wrote:
> I know squat about how to implement this, but I've been considering
> picking the low hanging fruit on that tree and patching up PG to try
> the concept. Many of the items above would require a thread-safe
> execution engine, which may be quite hard to get and have a
> significant performance hit. Some don't, like parallel sort.

This was just discussed on -hackers yesterday -- see thread
'multithreaded query planner'.  In short, judging by the comments of
some of the smartest people working on this project, it sounds like
using threads to attack this is not going to happen, ever.  Note you
can probably still get parallel execution in other ways, using
processes, shared memory, etc, so I'd consider researching in that
direction.

merlin

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Can lots of small writes badly hamper reads from other tables?
Next
From: Claudio Freire
Date:
Subject: Re: PostgreSQL Parallel Processing !