Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Space for pg_dump
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
- Cc: General postgres mailing list <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Space for pg_dump
- Date: Tue, 31 Mar 2009 16:47:09 +0100
- Message-id: <49D23AFD.9070900@archonet.com> <text/plain>
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
- References:
- Space for pg_dump
- From: SHARMILA JOTHIRAJAH
- Space for pg_dump
- Prev by Date: Re: Server Performance
- Next by Date: Re: weird problem with PG 8.1
- Previous by thread: Space for pg_dump
- Next by thread: Re: Space for pg_dump
- Indexes: