pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedBeowulf 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