From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Merlin Moncure <mmoncure(at)gmail(dot)com>,
Christopher Browne <cbbrowne(at)gmail(dot)com>, Frederico <zepfred(at)gmail(dot)com>,
"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Multithread Query Planner
Date:
2012-01-24 16:25:59
Message-ID:
6870.1327422359@sss.pgh.pa.us (view raw or flat )
Thread:
2012-01-13 20:14:24 from Frederico <zepfred(at)gmail(dot)com>
2012-01-13 20:29:03 from Christopher Browne <cbbrowne(at)gmail(dot)com>
2012-01-13 22:47:51 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-01-14 09:43:54 from Frederico <zepfred(at)gmail(dot)com>
2012-01-14 11:44:46 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-01-23 19:45:34 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-01-24 16:00:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-24 16:25:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-01-24 16:29:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-27 13:58:59 from "Fred&Dani&Pandora" <fred(at)nti(dot)ufop(dot)br>
2012-01-27 19:56:31 from "Pierre C" <lists(at)peufeu(dot)com>
2012-01-30 15:03:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-14 13:42:01 from Thomas Munro <munro(at)ip9(dot)org>
2012-01-23 11:59:21 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
Lists:
pgsql-hackers
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> I doubt it. Almost nothing in the backend is thread-safe. You can't
> acquire a heavyweight lock, a lightweight lock, or a spinlock. You
> can't do anything that might elog() or ereport(). None of those
> things are reentrant.
Not to mention palloc, another extremely fundamental and non-reentrant
subsystem.
Possibly we could work on making all that stuff re-entrant, but it would
be a huge amount of work for a distant and uncertain payoff.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2012-01-24 16:29:04
Subject : Re: Multithread Query Planner
Previous :From : Jaime CasanovaDate : 2012-01-24 16:24:08
Subject : Re: Measuring relation free space