Re: Space for pg_dump

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Space for pg_dump
Дата
Msg-id 49D23AFD.9070900@archonet.com
обсуждение исходный текст
Ответ на Space for pg_dump  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
Список pgsql-general
SHARMILA JOTHIRAJAH wrote:
> Hi,
> How much space does a pg_dump usually take?
> One of my databases is 600GB.... How much  space do I need to dump this?

That will depend on how many indexes etc. make up that 600GB. Also how
compressible your data is if you are using -Fc. Certainly less than a
"live" database, but by how much it's difficult to say.

--
  Richard Huxton
  Archonet Ltd

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Server Performance
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: weird problem with PG 8.1