[rt-devel] Postgres performance.

[Greg Stark]

"Aidan Mountford" <aidan at oz.to> writes:

> Yep - Can do....
> 
> The original query looks like this....
> 
> SELECT DISTINCT main.*
>    FROM  Users main,
>          Principals Principals_1,
>          Groups Groups_2,
>          Principals Principals_3,
>          Principals Principals_4,
>          ACL ACL_5,
>          CachedGroupMembers CachedGroupMembers_6,
>          CachedGroupMembers CachedGroupMembers_7

Can you post (or send me) the results of "explain analyze" on this and the
optimized query?

-- 
greg