pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Beowulf Cluster & Postgresql?
3+ messages / 3 participants
[nested] [flat]

* Beowulf Cluster & Postgresql?
@ 2004-07-21 20:45 joe <joe@avsupport.com>
  2004-07-21 21:08 ` Re: Beowulf Cluster & Postgresql? Scott Marlowe <smarlowe@qwest.net>
  2004-07-22 02:47 ` Re: Beowulf Cluster & Postgresql? Mark Kirkwood <markir@coretech.co.nz>
  0 siblings, 2 replies; 3+ messages in thread

From: joe @ 2004-07-21 20:45 UTC (permalink / raw)
  To: pgsql-performance

Hi all,
	I was wondering if part or all of Postgres would be able to take
advantage of a beowulf cluster to increase performance?  If not then why
not, and if so then how would/could it benefit from being on a cluster?

	Thanks for the enlightenment in advance.

-Joe





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Beowulf Cluster & Postgresql?
  2004-07-21 20:45 Beowulf Cluster & Postgresql? joe <joe@avsupport.com>
@ 2004-07-21 21:08 ` Scott Marlowe <smarlowe@qwest.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Scott Marlowe @ 2004-07-21 21:08 UTC (permalink / raw)
  To: joe <joe@avsupport.com>; +Cc: pgsql-performance

On Wed, 2004-07-21 at 14:45, joe wrote:
> Hi all,
> 	I was wondering if part or all of Postgres would be able to take
> advantage of a beowulf cluster to increase performance?  If not then why
> not, and if so then how would/could it benefit from being on a cluster?
> 
> 	Thanks for the enlightenment in advance.

That type of clustering helps with large parallel processes that are
loosely interrelated or none at all.

In PostgreSQL, as in most databases, all actions that change the data in
the database tend to be highly interrelated, so it becomes very
expensive to pass all that locking information back and forth.  The very
thing a cluster would be good at, lots of reads, very few writies, is
the antithesis of what postgresql is built to be good at, lots of writes
as well as lots of reads.

Basically, clustering tends to make the database faster at reads and
slower at writes.  While there are clustering solutions out there,
Beowulf clustering is oriented towards highly parallel CPU intensive
workloads, while PostgreSQL tends to be I/O intensive, and since all the
data needs to be stored in one "master" place, adding nodes doesn't
usually help with making writes faster.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Beowulf Cluster & Postgresql?
  2004-07-21 20:45 Beowulf Cluster & Postgresql? joe <joe@avsupport.com>
@ 2004-07-22 02:47 ` Mark Kirkwood <markir@coretech.co.nz>
  1 sibling, 0 replies; 3+ messages in thread

From: Mark Kirkwood @ 2004-07-22 02:47 UTC (permalink / raw)
  To: joe <joe@avsupport.com>; +Cc: pgsql-performance

You might want to take a look at Matt Dillon's Backplane database. It is 
designed to work in a multi-node environment :

http://www.backplane.com/

regards

Mark
joe wrote:

>Hi all,
>	I was wondering if part or all of Postgres would be able to take
>advantage of a beowulf cluster to increase performance?  If not then why
>not, and if so then how would/could it benefit from being on a cluster?
>
>	Thanks for the enlightenment in advance.
>
>-Joe
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>  
>



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-07-22 02:47 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-21 20:45 Beowulf Cluster & Postgresql? joe <joe@avsupport.com>
2004-07-21 21:08 ` Scott Marlowe <smarlowe@qwest.net>
2004-07-22 02:47 ` Mark Kirkwood <markir@coretech.co.nz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox