From: | Venkata Balaji Nagothi <vbnpgc(at)gmail(dot)com> |
---|---|
To: | tejaswinihj24(at)yahoo(dot)co(dot)in |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #9424: Database size increased by 10MB everyday |
Date: | 2014-03-03 23:55:53 |
Message-ID: | CAHBAh5v+RtRnX=ZOE_eY3r0Ju7PZMc1n2n6tP3L1Qf7aWFbRXQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Mar 4, 2014 at 2:48 AM, <tejaswinihj24(at)yahoo(dot)co(dot)in> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 9424
> Logged by: Tejaswini
> Email address: tejaswinihj24(at)yahoo(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-03-04 00:00:49 | Re: BUG #9430: Strange error during pg_dump with concurrent alter table working |
Previous Message | Tom Lane | 2014-03-03 23:52:42 | Re: BUG #9416: Setting up postgresql-9.1 (9.1.12-0wheezy1) Fails Configuration |