Re: [PERFORM] Sunfire X4500 recommendations

2007-03-27 Thread david
On Tue, 27 Mar 2007, Matt Smiley wrote: The goal is to calculate the probability of data loss when we loose a certain number of disks within a short timespan (e.g. loosing a 2nd disk before replacing+rebuilding the 1st one). For RAID 10, 50, and Z, we will loose data if any disk gr

Re: [PERFORM] Sunfire X4500 recommendations

2007-03-27 Thread Matt Smiley
Hi Dimitri, First of all, thanks again for the great feedback! Yes, my I/O load is mostly read operations. There are some bulk writes done in the background periodically throughout the day, but these are not as time-sensitive. I'll have to do some testing to find the best balance of read vs.

Re: [PERFORM] How to enable jdbc???

2007-03-27 Thread Joshua D. Drake
Michael Dengler wrote: Hi, In postgres 7.4.* I had to pass --with-java to the configure script for jdbc support. Does postgres 8.2* include it by default? If not, how do I enable it? Just download the driver from jdbc.postgresql.org Thanks Miguel ---(end of broadc

[PERFORM] How to enable jdbc???

2007-03-27 Thread Michael Dengler
Hi, In postgres 7.4.* I had to pass --with-java to the configure script for jdbc support. Does postgres 8.2* include it by default? If not, how do I enable it? Thanks Miguel ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [PERFORM] [GENERAL] ERROR: out of shared memory

2007-03-27 Thread Tom Lane
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes: > It seems that the legacy application creates tables dynamically and the > number of the created tables depends on the size of the input of the > application. For the specific input which generated that error I've > estimated a number of created tabl

Re: [PERFORM] [GENERAL] ERROR: out of shared memory

2007-03-27 Thread Merlin Moncure
On 3/26/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes: >I have to manage an application written in java which call another module > written in java which uses Postgre DBMS in a Linux environment. I'm new to > Postgres. The problem is that for large amo

Re: [PERFORM] Nested Loop

2007-03-27 Thread Ragnar
On þri, 2007-03-27 at 16:13 +0530, Gauri Kanekar wrote: > > SELECT rs.id AS sid, rs.name AS sname, rc.id AS campid, rc.name AS > campname, rc.rev_type AS revtype, rc.act_type AS actntype, ra.id AS > advid, ra.name AS advname, rpt_chn.id AS chanid, rpt_chn.name AS > channame, rpt_cre.dn AS dn, SUM

Re: [PERFORM] Nested Loop

2007-03-27 Thread Gauri Kanekar
Hi, here is the query SELECT rs.id AS sid, rs.name AS sname, rc.id AS campid, rc.name AS campname, rc.rev_type AS revtype, rc.act_type AS actntype, ra.id AS advid, ra.name AS advname, rpt_chn.id AS chanid, rpt_chn.name AS channame, rpt_cre.dn AS dn, SUM(rm.imdel) AS impression, SUM(rm.cdel) AS c