Re: [cobalt-developers] postgresql indexes

[Rene Luria <operator@xxxxxxxxxxxxx>]

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 <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.
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers

-- 
Rene Luria <operator@xxxxxxxxxxxxx>
Unix Administrator - Infomaniak Network SA