On Fri, Nov 04, 2011 at 05:25:25PM +0000, John Hodrien wrote:
>
> I'm entirely out of my depth on this one, I'll run it past someone else
> locally in case that's any help, as I'm not able to contribute a whole lot on
> this personally.
Well, the thing did improve a bit, even if in very tiny detail -- the
original
-> Seq Scan on rhnconfigfile cf (cost=0.00..28.25 rows=1 width=29) (actual
time=0.544..2.820 rows=1 loops=1)
Filter: (config_file_name_id =
lookup_config_filename('/var/lib/sss/db/cache_default.ldb'::character vary
became
-> Seq Scan on rhnconfigfile cf (cost=0.00..3.25 rows=1 width=29) (actual
time=0.019..0.047 rows=1 loops=1)
Filter: (config_file_name_id = 28::numeric)
so this particular thing improved from taking 2+ seconds to deep
subsecond.
Now it's time to tackle the next things.
Do you have your database freshly analyzed, by the way?
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
