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
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
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
"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
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?
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
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.
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
