[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[cobalt-developers] postgresql indexes
- Subject: [cobalt-developers] postgresql indexes
- From: Rene Luria <operator@xxxxxxxxxxxxx>
- Date: Tue Jan 22 05:40:03 2002
- List-id: Discussion Forum for developers on Sun Cobalt Networks products <cobalt-developers.list.cobalt.com>
Hello.
On one of my RaQ3 I have some kind of strange happenings:
In the internal postgresql databases,
I have some system indexes too big:
15M /home/pgsql/base/cobalt/pg_attribute_attrelid_index
54M /home/pgsql/base/cobalt/pg_attribute_relid_attnam_index
20M /home/pgsql/base/cobalt/pg_attribute_relid_attnum_index
that are not wiped with vacuum
Is there a way to compress or drop them?
(This is only happening in few of my RaQs... not all of them)
--
Rene Luria <operator@xxxxxxxxxxxxx>
Unix Administrator - Infomaniak Network SA