Re: BUG #9424: Database size increased by 10MB everyday

On Tue, Mar 4, 2014 at 2:48 AM, <tejaswinihj24@yahoo.co.in> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      9424
> Logged by:          Tejaswini
> Email address:      tejaswinihj24@yahoo.co.in
> PostgreSQL version: 9.2.5
> Operating system:   Windows
> Description:
>
> I am using Windows 2008 R2 and PostgreSQL 9.2.5
>
> Each day, the DB backup is increased by about 10 MB. On
> investigation, it was discovered that table size of one table used by the
> application is increasing on daily basis by about 60MB. It appears
> that that the formula / expression queue cleanup job that is scheduled
> for every half an hour is not running properly.
>

Could you help us know what kind of activity the said table is subjected to
in much more detail ?

Does the clean-up job mean that you have scheduled a job to clean-up some
archival/in-active data ? or is it a some kind of maintenance job ?

Table size can grow for different reasons - it could be Bloats, Toast etc.

Regards,
Venkata Balaji N

Fujitsu Australia