[Spacewalk-list] Postgres spacewalk

John Hodrien J.H.Hodrien at leeds.ac.uk
Mon Nov 21 10:13:38 UTC 2011


On Mon, 21 Nov 2011, Jan Pazdziora wrote:

> 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)

I guess I was being too negative...

> 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?

No.  ANALYSE; or is there more to it?

jh




More information about the Spacewalk-list mailing list