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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: After dump of 4.2 GB SQL file Equal to hard disk space???
Дата
Msg-id CAKFQuwZTq-OLfMt5GGfzVOx_vEkFuWT3END6sYtqhkE5uXzBuw@mail.gmail.com
обсуждение исходный текст
Ответ на After dump of 4.2 GB SQL file Equal to hard disk space???  (Kirti Pathak <kirtipathak121@gmail.com>)
Список pgsql-sql
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Kirti Pathak
Дата:
Сообщение: After dump of 4.2 GB SQL file Equal to hard disk space???
Следующее
От: "agharta82@gmail.com"
Дата:
Сообщение: Group by column alias where same-column-name already exists