Re: Fwd: Regarding change in the size of database
| От | Jayadevan M |
|---|---|
| Тема | Re: Fwd: Regarding change in the size of database |
| Дата | |
| Msg-id | CAFS1N4iJfQSECDr01Nw-NwO=adfV8qwPDoDtS-Jv6OeKLMEb+A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Fwd: Regarding change in the size of database (harish Reddy <harishr536@gmail.com>) |
| Ответы |
Re: Fwd: Regarding change in the size of database
|
| Список | pgsql-sql |
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 databaseHi 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 solutionThanks 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 по дате отправления: