Re: Parallell Optimizer

On 2013-06-07 19:09, Fred&Dani&Pandora&Aquiles wrote:
> I asked a while ago in this group about the possibility to implement a
> parallel planner in a multithread way, and the replies were that the
> proposed approach couldn't be implemented, because the postgres is not
> thread-safe. With the new feature Background Worker Processes, such
> implementation would be possible? If yes, do you can see possible
> problems in implement this approach, for example, the bgprocess can't
> access some planning core functions like make_join_rel, acess them in
> parallel and so on. I want start a research to work in a parallel
> planner in postgres, I succeeded in in the DBMS H2, but my first
> option still is the postgres, and any help is welcome.

The topic has been researched and experimented with on PostgreSQL 8.3,
described in a vldb-2008 paper called Parallelizing Query Optimization,
available on http://www.vldb.org/pvldb/1/1453882.pdf

regards,
Yeb

PS: apologies for redundant posting.