pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Spiegelberg <gspiegelberg@cranel.com>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: Kris Kiger <kris@musicrebellion.com>
Cc: pgsql-admin@postgresql.org, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: Clustering Postgres
Date: Thu, 27 May 2004 15:17:55 -0400
Message-ID: <40B63EE3.9000405@cranel.com> (raw)
In-Reply-To: <200405260951.41184.xzilla@users.sourceforge.net>
References: <20030310205101.65721.qmail@web41607.mail.yahoo.com>
	<1085172198.9127.1549.camel@camel>
	<40B1FFDC.9040303@cranel.com>
	<200405260951.41184.xzilla@users.sourceforge.net>

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.

Greg



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:
> 
>>Robert,
>>
>>I am currently evaluating PolyServe Matrix Server which is a clustering
>>solution including a clustered file system (mounted read-write
>>everywhere).
>>
>>Anything special anyone wants to know?  I'm using PostgreSQL 7.4.2 in
>>a Linux cluster.
>>
>>Greg
>>
>>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.
>>>>
>>>>http://www.linuxlabs.com/clusgres.html
>>>>
>>>>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@cranel.com
Technology. Integrity. Focus. V-Solve!




view thread (8+ messages)

Message-ID: <40B63EE3.9000405@cranel.com>
Permalink:  ../40B63EE3.9000405@cranel.com/
Also on:    postgresql.org/message-id/40B63EE3.9000405@cranel.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gspiegelberg@cranel.com, xzilla@users.sourceforge.net, kris@musicrebellion.com, pgsql-general@postgresql.org
  Subject: Re: Clustering Postgres
  In-Reply-To: <40B63EE3.9000405@cranel.com>
  References: <20030310205101.65721.qmail@web41607.mail.yahoo.com> <1085172198.9127.1549.camel@camel> <40B1FFDC.9040303@cranel.com> <200405260951.41184.xzilla@users.sourceforge.net> <40B63EE3.9000405@cranel.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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