Re: Clustering Postgres

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!