"Todd Fulton" <[EMAIL PROTECTED]> writes:
> prod=# explain analyze SELECT t.tgpid, t.directoryname, t.templateid,
> count(*) AS requested FROM (spk_tgp t JOIN spk_tgplog l ON ((t.tgpid =
> l.tgpid))) GROUP BY t.tgpid, t.directoryname, t.templateid;
> NOTICE: QUERY PLAN:
> Aggregate (cost=274045
On Feb 17, 2004, at 1:41 PM, Todd Fulton wrote:
spank_prod=# \d idx_spk_tgp_tgpid
Index "idx_spk_tgp_tgpid"
Column | Type
---+---
tgpid | bigint
directoryname | character varying(64)
btree
A couple of things to note:
1. What version
Column | Type
+
tgpid | bigint
btree
Todd
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of PC Drew
Sent: Tuesday, February 17, 2004 12:05 PM
To: Todd Fulton
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] long running query running too l
On Feb 17, 2004, at 10:06 AM, Todd Fulton wrote:
I’ve got a table with about 8 million rows and growing. I must run
reports daily off this table, and another smaller one. Typical query
– joins, groupings and aggregates included. This certain report takes
about 10 minutes on average and is g
