Postgres Pro
Downloads
Home   >   mailing lists

Re: After dump of 4.2 GB SQL file Equal to hard disk space??? - Mailing list pgsql-sql

From David G. Johnston
Subject Re: After dump of 4.2 GB SQL file Equal to hard disk space???
Date
Msg-id CAKFQuwZTq-OLfMt5GGfzVOx_vEkFuWT3END6sYtqhkE5uXzBuw@mail.gmail.com
Whole thread Raw
In response to After dump of 4.2 GB SQL file Equal to hard disk space???  (Kirti Pathak <kirtipathak121@gmail.com>)
List pgsql-sql
Tree view
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. 

pgsql-sql by date:

Previous
From: Kirti Pathak
Date:
Subject: After dump of 4.2 GB SQL file Equal to hard disk space???
Next
From: "agharta82@gmail.com"
Date:
Subject: Group by column alias where same-column-name already exists