Postgres Pro
Downloads
Home   >   mailing lists

Thread: After dump of 4.2 GB SQL file Equal to hard disk space???

After dump of 4.2 GB SQL file Equal to hard disk space???

From
Kirti Pathak
Date:
Hello,

I am Kirti Pathak from Delhi, India.

I have a database of size 4.2 GB SQL file. If I dump this file then I would like to know how big (in GB) it will be when loaded into PostgreSQL

Kindly suggest me something so that I can know about it.

Thank you.
--------------------
Best Regards,
Kirti Pathak
Astrolika.com

Re: After dump of 4.2 GB SQL file Equal to hard disk space???

From
"David G. Johnston"
Date:
On Thursday, December 6, 2018, Kirti Pathak <kirtipathak121@gmail.com> wrote:
I have a database of size 4.2 GB SQL file. If I dump this file then I would like to know how big (in GB) it will be when loaded into PostgreSQL

Without knowing what that 4.2GB is comprised of its difficult to estimate (it is anyway...).  Assume between 5 and 20 GB but probably closer to 10GB.  At that size why do you even care about estimating?

David J.