grouper-dev - Re: [grouper-dev] upgrade to 1.5 experience
Subject: Grouper Developers Forum
List archive
- From: Shilen Patel <>
- To: Jim Fox <>
- Cc: Chris Hyzer <>, "" <>
- Subject: Re: [grouper-dev] upgrade to 1.5 experience
- Date: Thu, 19 Nov 2009 18:16:10 -0500
On Nov 19, 2009, at 5:59 PM, Jim Fox wrote:
So there's some inefficiency here making that query unusable. Maybe
a missing index for
the query by user session?
Possibly or postgres is not optimized to run one of the queries. I'll
try to reproduce what you're seeing to figure out where things are
slowing down. If it's possible for you to send me an xml export of
your data (mask subjectIds and group names if needed), that would help.
I suppose a real DBA would have known, but ANALYZE also can greatly affect
the efficiency of queries. After doing an analyze on the three tables the
search with a user session is about the same as the root session.
We live and learn I guess. I'll add more groups and users to the database
and see what happens.
Ok cool. Though I thought you said you ran analyze in your last email. :) Did you have to run it more than once or did you run it with different parameters the second time?
Thanks!
-- Shilen
- upgrade to 1.5 experience, Jim Fox, 11/17/2009
- RE: [grouper-dev] upgrade to 1.5 experience, Chris Hyzer, 11/17/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Jim Fox, 11/17/2009
- RE: [grouper-dev] upgrade to 1.5 experience, Chris Hyzer, 11/18/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Shilen Patel, 11/18/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Jim Fox, 11/19/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Shilen Patel, 11/19/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Jim Fox, 11/19/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Shilen Patel, 11/19/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Jim Fox, 11/19/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Jim Fox, 11/19/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Shilen Patel, 11/19/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Jim Fox, 11/19/2009
- RE: [grouper-dev] upgrade to 1.5 experience, Chris Hyzer, 11/18/2009
- Re: [grouper-dev] upgrade to 1.5 experience, Jim Fox, 11/17/2009
- RE: [grouper-dev] upgrade to 1.5 experience, Chris Hyzer, 11/17/2009
Archive powered by MHonArc 2.6.16.