> 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
