From: | gmb <gmbouwer(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Performance issue: index not used on GROUP BY... |
Date: | 2014-09-03 19:50:26 |
Message-ID: | 1409773826818-5817622.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thanks for the feedback, everybody.
I spent a couple of days trying to optimise this;
As mentioned , the increased memory is not an option for me, as this query
is part of a report that can be run by any user on an ad hoc basis.
Allocating the required memory to any session on demand is not feasible in
this environment.
In the end , it seems to me that a more sustainable solution will be to
introduce an additional table to carry the summarized values and lookup on
that table in this type of scenario.
Regards
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Performance-issue-index-not-used-on-GROUP-BY-tp5816702p5817622.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Huang, Suya | 2014-09-04 07:33:08 | Re: query performance with hstore vs. non-hstore |
Previous Message | Takashi Horikawa | 2014-09-03 00:12:52 | Re: why after increase the hash table partitions, tpmc decrease |