Search Postgresql Archives

Re: [ADMIN] Clustering Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!


---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux