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 <[EMAIL PROTECTED]>
Director of Information Systems, Support Center of Washington
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
