From: | Joel Burton <jburton(at)scw(dot)org> |
---|---|
To: | Konstantinos Agouros <elwood(at)agouros(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Very long running query |
Date: | 2001-04-10 15:38:49 |
Message-ID: | Pine.LNX.4.21.0104101138220.21912-100000@olympus.scw.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10 Apr 2001, Konstantinos Agouros wrote:
> Hi,
>
> I have a query running for 97hours now and I am wondering if this can be made
> any faster.
> The Query is:
> insert into dailyreport select timestamp(date '1-8-2001'),a.category,'Observed',sum(b.count) as count from websensebycat a, netscapereduce b where a.url = b.url and a.action='Observed' and a.datum='1-8-2001' and b.datum='1-8-2001' and not exists (select url from urlcounts where urlcounts.url=b.url) group by a.category;
>
> The tables websensebycat and netscapereduce do have indices on it.
> Netscapereduce has 60020 entries and websensebycat has around 6000 entries.
> Urlcounts has 55 entries. The whole thing is running postgres 7.1RC2.
> Anybody has a tip to accelerate this. The whole thing is running on a E250 with
> 64Bit Solaris7.
what does explain command show about your query?
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2001-04-10 15:55:23 | Re: JDBC and Perl compiling problems w/ postgresql-7.1rc4 |
Previous Message | Steve Wampler | 2001-04-10 15:32:00 | pg_dump dying (and VACUUM ANALYZE woes)... |