Well, thanks a lot for your answer. In fact I did it already. Note all dump but juste cobalt database.
Then, I will have a look at postgresql archives 'cause it's not acceptable to get "holes" traces for 20Mo! On Tuesday 22 January 2002 15:18, you wrote: > > Date: Tue, 22 Jan 2002 14:28:13 +0100 > > From: Rene Luria <[EMAIL PROTECTED]> > > > > 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? > > You might try running pg_dumpall and then restoring your > databases from the dump. > > Vacuum deletes old OIDs, but will leave "holes" in your db file > IIRC. I _believe_ that future allocations will reclaim the > space instead of allocating new, but don't quote me on that. > > > Eddy > > --------------------------------------------------------------------------- > Brotsman & Dreger, Inc. - EverQuick Internet Division > Phone: +1 (316) 794-8922 Wichita/(Inter)national > Phone: +1 (785) 865-5885 Lawrence > --------------------------------------------------------------------------- > > Date: Mon, 21 May 2001 11:23:58 +0000 (GMT) > From: A Trap <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Please ignore this portion of my mail signature. > > These last few lines are a trap for address-harvesting spambots. Do NOT > send mail to <[EMAIL PROTECTED]>, or you are likely to be blocked. > > _______________________________________________ > cobalt-developers mailing list > [EMAIL PROTECTED] > http://list.cobalt.com/mailman/listinfo/cobalt-developers -- Rene Luria <[EMAIL PROTECTED]> Unix Administrator - Infomaniak Network SA _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
