Re: Parallell Optimizer - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Parallell Optimizer
Date
Msg-id 26617.1370629630@sss.pgh.pa.us
Whole thread Raw
In response to Parallell Optimizer  ("Fred&Dani&Pandora&Aquiles" <fred@nti.ufop.br>)
Responses Re: Parallell Optimizer  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
"Fred&Dani&Pandora&Aquiles" <fred@nti.ufop.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



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Freezing without write I/O
Next
From: Simon Riggs
Date:
Subject: Re: Freezing without write I/O