Thread: Parallelizing PostgreSQL for Cluster
Hi! Is anyone looking at making postgreSQL scalable across a cluster of PCs? That is, we have postgreSQL exuting queries which can be parallelised across a cluster, either something along Informix's method of fragmenting the tables across multiple disks, or Oracle's method of using a shared disk (global file)architecture. It would be interesting to have PostrgreSQL sitting on a Beowulf cluster giving Informix XPS or Oracle OPS a run for their money :-) Thanks for any info. Laurence
One of the long-term projects that PostgreSQL, Inc is planning on working on is exactly this, unless someone jumps at it before we get a chance to... On Thu, 3 Jun 1999, Laurence Liew wrote: > Hi! > > Is anyone looking at making postgreSQL scalable across a cluster of PCs? > That is, we have postgreSQL exuting queries which can be parallelised across > a cluster, either something along Informix's method of fragmenting the > tables across multiple disks, or Oracle's method of using a shared disk > (global file)architecture. > > It would be interesting to have PostrgreSQL sitting on a Beowulf cluster > giving Informix XPS or Oracle OPS a run for their money :-) > > Thanks for any info. > > Laurence > > > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
On Thu, 3 Jun 1999, The Hermit Hacker wrote: # One of the long-term projects that PostgreSQL, Inc is planning on # working on is exactly this, unless someone jumps at it before we get a # chance to... It should be a trivial change, right? :) # On Thu, 3 Jun 1999, Laurence Liew wrote: # # > Hi! # > # > Is anyone looking at making postgreSQL scalable across a cluster of PCs? # > That is, we have postgreSQL exuting queries which can be parallelised across # > a cluster, either something along Informix's method of fragmenting the # > tables across multiple disks, or Oracle's method of using a shared disk # > (global file)architecture. # > # > It would be interesting to have PostrgreSQL sitting on a Beowulf cluster # > giving Informix XPS or Oracle OPS a run for their money :-) # > # > Thanks for any info. # > # > Laurence # > # > # > # > # # Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy # Systems Administrator @ hub.org # primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org # # # -- SA, beyond.com My girlfriend asked me which one I like better. pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net> | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE L_______________________ I hope the answer won't upset her. ____________
Dustin Sallings wrote: > > On Thu, 3 Jun 1999, The Hermit Hacker wrote: > > # One of the long-term projects that PostgreSQL, Inc is planning on > # working on is exactly this, unless someone jumps at it before we get a > # chance to... > > It should be a trivial change, right? :) Will it make it into 6.5? :) > > # On Thu, 3 Jun 1999, Laurence Liew wrote: > # > # > Hi! > # > > # > Is anyone looking at making postgreSQL scalable across a cluster of PCs? > # > That is, we have postgreSQL exuting queries which can be parallelised across > # > a cluster, either something along Informix's method of fragmenting the > # > tables across multiple disks, or Oracle's method of using a shared disk > # > (global file)architecture. > # > > # > It would be interesting to have PostrgreSQL sitting on a Beowulf cluster > # > giving Informix XPS or Oracle OPS a run for their money :-) > # > > # > Thanks for any info. > # > > # > Laurence > # > > # > > # > > # > > # > # Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy > # Systems Administrator @ hub.org > # primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org > # > # > # > > -- > SA, beyond.com My girlfriend asked me which one I like better. > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net> > | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE > L_______________________ I hope the answer won't upset her. ____________