Re: table growing

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Stephane Tessier <stephane(at)info-logika(dot)com>
Cc: "'scott(dot)marlowe'" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: table growing
Date: 2002-11-08 16:03:55
Message-ID: m34rasvyj8.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephane Tessier <stephane(at)info-logika(dot)com> writes:

> The database version is Postgresql 7.2.1
> And I run 4 time/day vacuum but I cannot lock tables so I don't want to
> use a vacuum full.... the question is:is it a problem with pgsql or
> Is it normal to have to stop the database to do maintenance...
> My boss WANT (!!!!!) that we find the trouble but is there a trouble????

Is it the table or an index that's growing?

If it's the table, it may be growing too fast for VACUUM to clean up.
If you have heavy update/delete-insert activity, try running VACUUM
more often (you can run it every few minutes if you have to, since it
doesn't block anything). If there's any way you can run VACUUM FULL
at least once a day (during non-peak hours) it might help as well.

If it's an index that's growing, right now REINDEX is the only way to
reclaim that space. There are plans to hopefully fix VACUUM to do it,
but it's not currently done.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2002-11-08 16:06:54 Foreign key deadlocks
Previous Message Doug McNaught 2002-11-08 15:59:44 Re: dates