Skip site navigation (1) Skip section navigation (2)

Re: Beowulf Cluster & Postgresql?

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "joe" <joe(at)avsupport(dot)com>
Cc: "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Beowulf Cluster & Postgresql?
Date: 2004-07-21 21:08:30
Message-ID: 1090444110.709.38.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: 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.

In response to

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2004-07-22 02:47:28
Subject: Re: Beowulf Cluster & Postgresql?
Previous:From: joeDate: 2004-07-21 20:45:56
Subject: Beowulf Cluster & Postgresql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group