Re: Scaling up PostgreSQL in Multiple CPU / Dual Core

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Martha Stewart called it a Good Thing when smarlowe@xxxxxxxxxxxxxxxxx (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? 


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux