Re: *very* slow query to summarize data for a month ...

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
Cc: scrappy(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: *very* slow query to summarize data for a month ...
Date: 2003-11-10 22:51:10
Message-ID: 87u15bx2g1.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Patrick Hatcher" <PHatcher(at)macys(dot)com> writes:
> Do you have an index on ts.bytes? Josh had suggested this and after I put
> it on my summed fields, I saw a speed increase.

What's the reasoning behind this? ISTM that sum() should never use an
index, nor would it benefit from using one.

-Neil

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2003-11-10 23:15:41 Re: *very* slow query to summarize data for a month ...
Previous Message Josh Berkus 2003-11-10 20:59:03 Re: *very* slow query to summarize data for a month ...