Re: index files still growing

From: Doug McNaught <doug(at)wireboard(dot)com>
To: carex <bk226157(at)skynet(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: index files still growing
Date: 2001-10-23 20:53:23
Message-ID: m3u1wqdqnw.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

carex <bk226157(at)skynet(dot)be> writes:

> I am using Postgresql 7.0.2
> The problem is that my index files are still growing.
> ( and I vacuum each night !! )
> My solution is to DROP & CREATE my indexes files once
> a week.
>
> Is this a known problem with 7.0.2 ??

It's a known problem in general. VACUUM doesn't vacuum indexes. :(

> Is it solved in 7.1.3 ??

No.

Your solution is currently the only one available. Not pretty, but it
works.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephanie.Wall 2001-10-23 21:06:23 Free PostgreSQL book
Previous Message Peter Eisentraut 2001-10-23 20:42:36 Re: Dump Error...