Re: index files still growing - Mailing list pgsql-general

From Doug McNaught
Subject Re: index files still growing
Date
Msg-id m3u1wqdqnw.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to index files still growing  (carex <bk226157@skynet.be>)
Responses Re: index files still growing  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
carex <bk226157@skynet.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

pgsql-general by date:

Previous
From: Keary Suska
Date:
Subject: Re: Listing users
Next
From: Tatsuo Ishii
Date:
Subject: Re: Charset problem