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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Kirti Pathak <kirtipathak121(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: After dump of 4.2 GB SQL file Equal to hard disk space???
Date: 2018-12-07 01:31:50
Message-ID: CAKFQuwZTq-OLfMt5GGfzVOx_vEkFuWT3END6sYtqhkE5uXzBuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday, December 6, 2018, Kirti Pathak <kirtipathak121(at)gmail(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message agharta82@gmail.com 2018-12-11 16:39:51 Group by column alias where same-column-name already exists
Previous Message Kirti Pathak 2018-12-06 23:44:34 After dump of 4.2 GB SQL file Equal to hard disk space???