Re: [cobalt-developers] postgresql indexes

["E.B. Dreger" <eddy+public+spam@xxxxxxxxxxxxxxxxx>]

> Date: Tue, 22 Jan 2002 14:28:13 +0100
> From: Rene Luria <operator@xxxxxxxxxxxxx>

> 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 <blacklist@xxxxxxxxx>
To: blacklist@xxxxxxxxx
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 <blacklist@xxxxxxxxx>, or you are likely to be blocked.