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

Re: Multithread Query Planner

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: Frederico <zepfred(at)gmail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Multithread Query Planner
Date: 2012-01-23 11:59:21
Message-ID: 4F1D4B99.1040902@gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 2012-01-13 21:14, Frederico wrote:
> Hi folks.
>
> Is there any restriction in create and start threads inside Postgres?
>
> I'm trying to develop a multithread planner, and some times is raised a exception of access memory.
>
> I'm debugging the code to see if is a bug in the planner, but until now, I still not found. I tried to use the same memory context of root process and create a new context to each new thread, but doesn't worked.
>
>
> Any tips?

Not sure if it is of any use to you, but the vldb paper 'Parallelizing 
Query Optimization' http://www.vldb.org/pvldb describes a experimental 
implementation in PostgreSQL.

regards,
Yeb


In response to

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2012-01-23 12:23:52
Subject: Re: WAL Restore process during recovery
Previous:From: Hitoshi HaradaDate: 2012-01-23 11:20:05
Subject: Re: Patch: Allow SQL-language functions to reference parameters by parameter name

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