Re: Postgres Databases growing without much reason

On Fri, 14 Feb 2003, Stephan Szabo wrote:

>
> On Fri, 14 Feb 2003, Andreas Rust wrote:
>
> > At 14:03 14.02.03, you wrote:
> > >On Fri, Feb 14, 2003 at 11:58:00AM +0100, Andreas Rust wrote:
> > > > I completely dumped the dbase, dropped and restored it and instead of 2 GB
> > > > it was
> > > > only using 150 MB then. Now, after having this running for about 2 Weeks
> > > > constantly,
> > > > the performance is falling down again and the database grew up to 550 MB
> > > > again, although
> > > > there was not much inserted into the dbase-tables.
> > >
> > >Can you find which files in the data directory are growing? They're numbered
> > >by oid, which you can lookup in pg_class.
> >
> > Yes, I can ...
> >
> > After an advice, I just did "vacuum full" instead of analyze and that
> > brought the DB
> > down to some 350 MB again ... no time this week anymore, but will check
> > into that
> > middle next week again.
>
> As a note for when you come back to this, if vacuum full reclaims a bunch
> of space, but vacuum (without full) ends up with unbounded growth, it's
> possible that you're exceeding the free space map settings and will need
> to look at increasing them.
>

But the original message said there was very little inserted or updated (at
least I think it said updated) and no rules or triggers. I was thinking that
there was something going on here that the poster wasn't aware off. Perhaps the
app does do updates that don't change the data, for some reason, and so the
poster doesn't see any inserts/updates from his reports.

--
Nigel J. Andrews