Re: [HACKERS] postgresql clustering

Thanks for your reply Luke. Bizgres looks like a very promissing project. I'll be sure to follow it. Thanks to everyone for their comments. I'm starting to understand the truth behind the hype and where these performance gains and hits stem from. -Dan ---(end of

Re: [HACKERS] postgresql clustering

What about clustered filesystems? At first blush I would think the overhead of something like GFS might kill performance. Could one potentially achieve a fail-over config using multiple nodes with GFS, each having there own instance of PostgreSQL (but only one running at any given moment)?

Fwd: Re: [HACKERS] postgresql clustering

What is the relationship between database support for clustering and grid computing and support for distributed databases? Two-phase COMMIT is comming in 8.1. What effect will this have in promoting FOSS grid support or distribution solutions for Postgresql? ---(end

Re: [HACKERS] postgresql clustering

Dan, On 9/29/05 3:23 PM, Daniel Duvall [EMAIL PROTECTED] wrote: What about clustered filesystems? At first blush I would think the overhead of something like GFS might kill performance. Could one potentially achieve a fail-over config using multiple nodes with GFS, each having there own

Re: [HACKERS] postgresql clustering

Luke Lonergan wrote: Dan, On 9/29/05 3:23 PM, Daniel Duvall [EMAIL PROTECTED] wrote: What about clustered filesystems? At first blush I would think the overhead of something like GFS might kill performance. Could one potentially achieve a fail-over config using multiple nodes with GFS,

Re: [HACKERS] postgresql clustering

While clustering in some circles may be an open-ended buzzword -- mainly the commercial DB marketing crowd -- there are concepts beneath the bull that are even inherent in the name. However, I understand your point. From what I've researched, the concepts and practices seem to fall under one of

Re: [HACKERS] postgresql clustering

Daniel Duvall schrieb: While clustering in some circles may be an open-ended buzzword -- mainly the commercial DB marketing crowd -- there are concepts beneath the bull that are even inherent in the name. However, I understand your point. From what I've researched, the concepts and practices

Re: [HACKERS] postgresql clustering

On 9/29/05, Tino Wildenhain [EMAIL PROTECTED] wrote: Well, I dont know why many people believe parallel executionautomatically means high performance. Actually most of the timethe performance is much worser this way.If your dataset remains statically and you do only read-only requets, you get

Re: [HACKERS] postgresql clustering

Daniel Duvall wrote: While clustering in some circles may be an open-ended buzzword -- mainly the commercial DB marketing crowd -- there are concepts beneath the bull that are even inherent in the name. However, I understand your point. From what I've researched, the concepts and practices

Re: [HACKERS] postgresql clustering

Jonah H. Harris schrieb: On 9/29/05, *Tino Wildenhain* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Well, I dont know why many people believe parallel execution automatically means high performance. Actually most of the time the performance is much worser this way. If your

Re: [HACKERS] postgresql clustering

Daniel, From what I've researched, the concepts and practices seem to fall under one of two abstract categorizations: fail-over (ok... high-availability), and parallel execution (high-performance... sure). While some consider the implementation of only one of these to qualify a cluster,

Re: [HACKERS] postgresql clustering

Daniel Duvall wrote: I've looked at PostgreSQL and EnterpriseDB, but I can't find anything definitive as far as clustering capabilities. What kinds of projects are there for clustering PgSQL, and are any of them mature enough for commercial apps? As you well know clustering means all and

Re: [HACKERS] postgresql clustering

Gaetano Mendola wrote: Daniel Duvall wrote: I've looked at PostgreSQL and EnterpriseDB, but I can't find anything definitive as far as clustering capabilities. What kinds of projects are there for clustering PgSQL, and are any of them mature enough for commercial apps? Are you

Re: [HACKERS] postgresql clustering

: +202 271 8794 (ext. 115) Fax : +202 2748335 Cell: +2010 5410035 http://www.citglobal.com -Original Message- From: David Fetter [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 8:12 PM To: Rafik Salama Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS

Re: [HACKERS] postgresql clustering

On Wed, Sep 21, 2005 at 08:01:08PM +0300, Rafik Salama wrote: Dear Sirs I know that that postgresql can be configured for high availability over a clustered environment using pgcluster, Do you have a case study showing this? I am currently studying in my masters the clustering using MPI

Re: [HACKERS] postgresql clustering

I think its a great idea to give it a shot, maybe you can present a proposal to the list of how you wish to go about it. There could be some experts on the list who may give you some input and direction. Aly. David Fetter wrote: On Wed, Sep 21, 2005 at 08:01:08PM +0300, Rafik Salama wrote:

Re: [HACKERS] postgresql clustering

:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 8:12 PM To: Rafik Salama Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] postgresql clustering On Wed, Sep 21, 2005 at 08:01:08PM +0300, Rafik Salama wrote: Dear Sirs I know that that postgresql can be configured for high

Re: [HACKERS] postgresql clustering

In the past couple years I've worked on several personal/business projects to cluster PostgreSQL and InnoDB (without MySQL). I've tested shared-nothing, shared-memory, and shared-disk models. IMHO, shared-disk is the only viable option for performance and/or large production business environments.