Re: Fwd: Regarding change in the size of database

Поиск
Список
Период
Сортировка
От harish Reddy
Тема Re: Fwd: Regarding change in the size of database
Дата
Msg-id CANiTL_zpTJZJxeNQJ5q3+9eGi03Y1TpbO4HpQrPCpmyySmrwfA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: Regarding change in the size of database  (Jayadevan M <maymala.jayadevan@gmail.com>)
Ответы Re: Fwd: Regarding change in the size of database
Список pgsql-sql
Дерево обсуждения
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.jayadevan@gmail.com> wrote:


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 по дате отправления: