Hello,
I am using postgresql 9.3 in Windows. I take data backup using pg_dump. The backup file size is 5 MB only. After that I insert 8 images using large object.
The total size of 8 images are 24 MB. After insert large object only, I take data backup using pg_dump. Now the backup file size becomes 246 MB. I really shocked. so I check database size using the following query
SELECT pg_size_pretty(pg_database_size('testdb'));
The return value is 710 MB.
What is the problem? How DB size increased extremely?
Thanks for your Suggestions.