On Thu, Jul 17, 2008 at 4:55 PM, Jessie Bryan <[EMAIL PROTECTED]> wrote: > On Thu, Jul 17, 2008 at 4:49 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: >> I'm not big expert on optimizing Pg queries using indexes. Below >> you'll find suggestions for some. >> >> But please run EXPLAIN for each query before creating any index and >> after. Without explains we can not help you precisely, just guessing. >> Also, please use some real constants in EXPLAIN, random strings and >> numbers will generate plans far from reality. > > Thanks for the guidance Ruslan, I'll see what I can find.. >
After talking to a friend, we've seem to have corrected the issue. The basic problem was the lack of indexes. Perhaps it's the size of our RT database. The problem for us was the sheer number records: rt3=> select count(*) from GroupMembers; count -------- 304977 (1 row) rt3=> rt3=> select count(*) from groups; count -------- 509925 (1 row) rt3=> Corrective Actions: CREATE INDEX groupmembers_gid on groupmembers ( groupid ); the slow query log is very quiet now.. -Jessie Bryan _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
