Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: Regarding change in the size of database - Mailing list pgsql-sql

From Jayadevan M
Subject Re: Fwd: Regarding change in the size of database
Date
Msg-id CAFS1N4iJfQSECDr01Nw-NwO=adfV8qwPDoDtS-Jv6OeKLMEb+A@mail.gmail.com
Whole thread Raw
In response to Fwd: Regarding change in the size of database  (harish Reddy <harishr536@gmail.com>)
Responses Re: Fwd: Regarding change in the size of database  (harish Reddy <harishr536@gmail.com>)
List pgsql-sql
Tree view


On Wed, Oct 26, 2016 at 10:31 AM, harish Reddy <harishr536@gmail.com> wrote:

---------- Forwarded message ----------
From: harish Reddy <harishr536@gmail.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

Proper vacuum is the solution.

Regards,
Jayadevan

pgsql-sql by date:

Previous
From: harish Reddy
Date:
Subject: Fwd: Regarding change in the size of database
Next
From: harish Reddy
Date:
Subject: Re: Fwd: Regarding change in the size of database