Re: Parallell Optimizer

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Fred&Dani&Pandora&Aquiles" <fred(at)nti(dot)ufop(dot)br>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Parallell Optimizer
Date: 2013-06-07 18:27:10
Message-ID: 26617.1370629630@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Fred&Dani&Pandora&Aquiles" <fred(at)nti(dot)ufop(dot)br> writes:
> 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?

I don't think that bgworkers as currently implemented make this any more
practical than it was before. The communication overhead with a
separate process would swamp any benefit in most cases.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2013-06-07 18:33:02 Re: Freezing without write I/O
Previous Message Heikki Linnakangas 2013-06-07 18:08:10 Re: Freezing without write I/O