Re: Scaling up PostgreSQL in Multiple CPU / Dual Core - Mailing list pgsql-performance

From Christopher Browne
Subject Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Date
Msg-id 87hd5olgyd.fsf@wolfe.cbbrowne.com
Whole thread Raw
In response to Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers  ("Jojo Paderes" <jojo.paderes@gmail.com>)
Responses Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
List pgsql-performance
Martha Stewart called it a Good Thing when smarlowe@g2switchworks.com (Scott Marlowe) wrote:
> On Thu, 2006-03-23 at 10:43, Joshua D. Drake wrote:
>> > Has someone been working on the problem of splitting a query into pieces
>> > and running it on multiple CPUs / multiple machines?  Yes.  Bizgress has
>> > done that.
>>
>> I believe that is limited to Bizgress MPP yes?
>
> Yep.  I hope that someday it will be released to the postgresql global
> dev group for inclusion.  Or at least parts of it.

Question: Does the Bizgress/MPP use threading for this concurrency?
Or forking?

If it does so via forking, that's more portable, and less dependent on
specific complexities of threading implementations (which amounts to
non-portability ;-)).

Most times Jan comes to town, we spend a few minutes musing about the
"splitting queries across threads" problem, and dismiss it again; if
there's the beginning of a "split across processes," that's decidedly
neat :-).
--
output = reverse("moc.liamg" "@" "enworbbc")
http://linuxfinances.info/info/internet.html
Why do we put suits in a garment bag, and put garments in a suitcase?

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Next
From: Theo Kramer
Date:
Subject: Re: Indexes with descending date columns