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

Re: Clustering Postgres

From: Greg Spiegelberg <gspiegelberg(at)cranel(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: Kris Kiger <kris(at)musicrebellion(dot)com>, pgsql-admin(at)postgresql(dot)org,"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Clustering Postgres
Date: 2004-05-27 19:17:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-general
Here's the basics basically because I ran out of time and budget to
actually purchase it but here's what I know.

1 day to install.  Installed RedHat ES 3.0 from scratch, and the
PolyServe process took perhaps 1.5 hours to install including a
kernel build and system reboot.  Roughly 2 hours into PolyServe I
had my first psfs (shared cluster) partition setup on my 1Gb SAN.

Just doing a basic dd to write 1.5GB and 5GB to an ext3 on the
same hardware produced roughly 115 MB/s and 107 MB/s respectively.
It's my understand that PostgreSQL won't create files largers than
2GB though.

Doing the same tests on the PolyServe file system (psfs) accomplished
the tasks in 117 MB/s and 109 MB/s, just slightly faster.

If you're familiar with Veritas Cluster Server it operates similiar
to it though I didn't have a chance to fully test it.

Given the budget I'd definitely take another look at it.


Robert Treat wrote:
> Some basics on how easy it is to install/configure and some before/after type 
> benchmarks showing how it affected performance.  Perferrably you could 
> measure simple vs. complex queries as well as update vs. insert performance. 
> If you're really ambitious you could try running one of the tpc style 
> benchmarks on the system, check the archives or the osdl site for more info 
> on getting these up and running.
> Robert Treat
> On Monday 24 May 2004 09:59, Greg Spiegelberg wrote:
>>I am currently evaluating PolyServe Matrix Server which is a clustering
>>solution including a clustered file system (mounted read-write
>>Anything special anyone wants to know?  I'm using PostgreSQL 7.4.2 in
>>a Linux cluster.
>>Robert Treat wrote:
>>>On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
>>>>Has anyone heard of clusgres or, better yet, had any experience with it?
>>>>I came across it while searching for active clustering projects.
>>>>Thanks in advance for the info!
>>>I have heard of it but I've not heard of any reports on these lists of
>>>how well it works. If you (or anyone else) gives it a spin please try to
>>>post an account to the list and/or if you send me the info it could
>>>probably make its way on to techdocs.
>>>Robert Treat

Greg Spiegelberg
  Product Development Manager
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg(at)cranel(dot)com
Technology. Integrity. Focus. V-Solve!

In response to

pgsql-admin by date

Next:From: Louie KwanDate: 2004-05-27 20:42:51
Subject: PostgreSQL is hanging up !?
Previous:From: Mitch PirtleDate: 2004-05-27 18:47:28
Subject: Re: PHP version with postgres 7.4

pgsql-general by date

Next:From: Richard HuxtonDate: 2004-05-27 19:22:57
Subject: Re: Database Size Limiting
Previous:From: Richard HuxtonDate: 2004-05-27 19:17:54
Subject: Re: Database Size Limiting

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