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