> Here most of the time is spent in the hash join for: > > Hash Cond: (cachedgroupmembers_2.memberid = main.id) >
What indexes do you have on cachedgroupmembers? (Also, I presume your Postgres is reasonably well tuned, autovacuumed, etc) _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com