Re: Space for pg_dump - Mailing list pgsql-general

From Richard Huxton
Subject Re: Space for pg_dump
Date
Msg-id 49D23AFD.9070900@archonet.com
Whole thread Raw
In response to Space for pg_dump  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Server Performance
Next
From: Scott Marlowe
Date:
Subject: Re: weird problem with PG 8.1