Postgres Pro
Downloads
Home   >   mailing lists

Re: *very* slow query to summarize data for a month ... - Mailing list pgsql-performance

From Neil Conway
Subject Re: *very* slow query to summarize data for a month ...
Date
Msg-id 87u15bx2g1.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: *very* slow query to summarize data for a month ...  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-performance
Tree view 
"Patrick Hatcher" <PHatcher@macys.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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: *very* slow query to summarize data for a month ...
Next
From: Neil Conway
Date:
Subject: Re: *very* slow query to summarize data for a month ...