Re: [ADMIN] Clustering Postgres

2004-05-27 Thread Greg Spiegelberg
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 Pol

Re: [ADMIN] Clustering Postgres

2004-05-26 Thread Robert Treat
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

Re: [ADMIN] Clustering Postgres

2004-05-24 Thread Ericson Smith
We'd be very interested in the performance, especially with the disk being used as in interconnect (I assume that that is being used to simulate global shared memory?) We did have a talk with the folks over at http://www.linuxlabs.com/clustgres They were honest enough to say that even with the D

Re: [ADMIN] Clustering Postgres

2004-05-24 Thread Greg Spiegelberg
2 dual PIII-1.4GHz Linux RedHat 3.0 servers each with onboard AIC7xxx and 2 U160 drives (mirrored), 2 GB of ECC memory, 2 onboard Intel Ether Pro 100Mbps type NIC's, 1 Qlogic 2310 HBA on a 1GBs SAN using a Candera 510 storage cluster with Xyratex SATA on the backend configured with 1+0 LUN's. It w

Re: [ADMIN] Clustering Postgres

2004-05-24 Thread Ericson Smith
Do you mean that you are actually testing this product now? If so, what's the hardware configuration (nodes, storage server, interconnects) that you are using? Warmest regards, Ericson Smith Tracking Specialist/DBA +---+-+ | http://www

Re: [ADMIN] Clustering Postgres

2004-05-24 Thread Greg Spiegelberg
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, Kr

Re: [ADMIN] Clustering Postgres

2004-05-21 Thread Robert Treat
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

[ADMIN] Clustering Postgres

2004-05-20 Thread Kris Kiger
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! Kris ---(end of broadcast)--- TIP 6: Hav