Re: Fwd: Regarding change in the size of database

Hi Jayadevan,

Firstly Thank you so much for your valuable information provided, So what
should i do for increasing my database performance? and could you suggest
me how to continue to the vacuum process and will it decrease my database
performance?

On Wed, Oct 26, 2016 at 7:07 PM, Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
wrote:

>
>
> On Wed, Oct 26, 2016 at 10:31 AM, harish Reddy <harishr536(at)gmail(dot)com>
> wrote:
>
>>
>> ---------- Forwarded message ----------
>> From: harish Reddy <harishr536(at)gmail(dot)com>
>>
>> Subject: Regarding change in the size of database
>>
>>
>>
>> Hi Sir,
>>
>> I had my PostgreSQL DB in Procduction environment was about *45GB* and
>> when I taken it's dump and restored into my local environment it was about*
>> 20GB* . I want to know what is going wrong and when i had observed it is
>> differing to a single table also so could you suggest us what is the issue
>> and possible solution and in a day it has incresed over 1 GB again
>> suggest me where can i get the solution
>>
>> Thanks and Regards
>> Harish Reddy
>>
>> Probably there was table bloat in your production environment. When you
> restored, the bloat would have disappeared. 20 GB is the actual size. Read
> details about bloat here
> http://dba.stackexchange.com/questions/126258/what-is-
> table-bloating-in-databases
>
> Proper vacuum is the solution.
>
> Regards,
> Jayadevan
>