[Spacewalk-list] Database -rhnsnapshotpackage monster-table with monster-index?

[Jonathan Hoser]

Dear all,

just a quick question from my end:
is it just us, or is 'rhnsnapshotpackage' by far the largest table in
the postgres database?

Currently we are seeing a 61GB table (1.19e+09 entries) and a 56GB index....

If this is abnormal in size, does anyone have a clue/idea/recipe on how
to shrink it?
For performance reasons we did try to shift our indices to a nice SSD,
but this one is... a different animal.

Best
-Jonathan

-- 
Jonathan Hoser, M.Sc.
Institute of Bioinformatics and System Biology

Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH)
Ingolstaedter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen (komm.)
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671