Re: database size grows (even after vacuum (full and analyze)).... - Mailing list pgsql-general

From Joao Miguel Ferreira
Subject Re: database size grows (even after vacuum (full and analyze))....
Date
Msg-id 1147110220.2418.116.camel@sandoval
Whole thread Raw
In response to Re: database size grows (even after vacuum (full and analyze))....  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
On Mon, 2006-05-08 at 18:07, Bruno Wolff III wrote:
> Please keep replies copied to the list so that others can learn from and
> contribute to the discussion. I don't remember where this was, but it looks
> like general is probably reasonable.

Sorry. I didn't notice. I'll keep that in mind.

> >
> > Yes, my tables contains ever grwoing values afected by a UNIQUE
> > constraint.
> >
> > What would I do next ?
> >
> > jmf
> > (Pg is 7.2, rpm install, Fedora Core 3)
>
> 7.2 is subject to index bloat for indexes where the column increase monotonicly
> and old values are deleted. In the short run you will want to schedule
> regular reindexes.

Well... that seems to answer my questions. Thanks.

>
> In the long run, you should upgrade. 7.2 is essentially without support. I
> beleive there is still a RHEL version using it that is in support, so a
> critical fix might get back ported.

I'll do that.

thanks

jmf




pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: database size grows (even after vacuum (full and analyze))....
Next
From: Tom Lane
Date:
Subject: Re: database size grows (even after vacuum (full and analyze))....