Re: [GENERAL] Space for pg_dump

2009-05-13 Thread Greg Smith
On Mon, 20 Apr 2009, Jan Otto wrote: If you have big toast tables you get wrong results with the query suggested at http://wiki.postgresql.org/wiki/Disk_Usage because it takes the toasted values not into account. I can't recall why I wrote that to filter out things in the pg_toast namespace i

Re: [GENERAL] Space for pg_dump

2009-04-20 Thread Jan Otto
On Apr 20, 2009, at 7:35 PM, Alvaro Herrera wrote: Jan Otto wrote: If you have big toast tables you get wrong results with the query suggested at http://wiki.postgresql.org/wiki/Disk_Usage because it takes the toasted values not into account. Now a fixed query which gets the sizes of the re

Re: [GENERAL] Space for pg_dump

2009-04-20 Thread Alvaro Herrera
Jan Otto wrote: > If you have big toast tables you get wrong results with the query > suggested > at http://wiki.postgresql.org/wiki/Disk_Usage because it takes the > toasted > values not into account. > Now a fixed query which gets the sizes of the related pg_toast_oid and > pg_toast_oid_

Re: [GENERAL] Space for pg_dump

2009-04-20 Thread Jan Otto
Hi, Rainer Bauer writes: Greg Smith wrote: Since running an entire pgdump can take forever on a big database, what I usually do here is start by running the disk usage query at http://wiki.postgresql.org/wiki/Disk_Usage Interesting. However, the query gives an error if the table name co

Re: [GENERAL] Space for pg_dump

2009-04-18 Thread Tom Lane
Rainer Bauer writes: > Greg Smith wrote: >> Since running an entire pgdump can take forever on a big database, what I >> usually do here is start by running the disk usage query at >> http://wiki.postgresql.org/wiki/Disk_Usage > Interesting. However, the query gives an error if the table name c

Re: [GENERAL] Space for pg_dump

2009-04-18 Thread Rainer Bauer
Greg Smith wrote: >On Tue, 31 Mar 2009, Scott Marlowe wrote: > >> Sadly, there is no exact maths for such things. If your database has >> tons of indexes and such, it might be 20 or 100 times bigger on disk >> than it will be during backup. If it's all compressible text with few >> indexes, it m

Re: [GENERAL] Space for pg_dump

2009-04-18 Thread Greg Smith
On Tue, 31 Mar 2009, Scott Marlowe wrote: Sadly, there is no exact maths for such things. If your database has tons of indexes and such, it might be 20 or 100 times bigger on disk than it will be during backup. If it's all compressible text with few indexes, it might be a 1:1 or so size. Sin

Re: [GENERAL] Space for pg_dump

2009-03-31 Thread hubert depesz lubaczewski
On Tue, Mar 31, 2009 at 08:57:28AM -0700, SHARMILA JOTHIRAJAH wrote: > > Note you can find out by doing: > > pg_dump dbname | wc > Yes...I could find the space used after creating the dump. > But I need to pre-allocate some space for storing these dumps I'm not sure if you realize that you don't n

Re: [GENERAL] Space for pg_dump

2009-03-31 Thread Scott Marlowe
On Tue, Mar 31, 2009 at 10:31 AM, SHARMILA JOTHIRAJAH wrote: > > > > --- On Tue, 3/31/09, Scott Marlowe wrote: > >> From: Scott Marlowe >> wrote: >> > But I need to pre-allocate some space for storing >> these dumps (there are other databases too that needs to be >> dumped). So Im trying to find

Re: [GENERAL] Space for pg_dump

2009-03-31 Thread SHARMILA JOTHIRAJAH
--- On Tue, 3/31/09, Scott Marlowe wrote: > From: Scott Marlowe > Subject: Re: [GENERAL] Space for pg_dump > To: "SHARMILA JOTHIRAJAH" > Cc: "General postgres mailing list" > Date: Tuesday, March 31, 2009, 12:07 PM > On Tue, Mar 31, 2009 at 9:5

Re: [GENERAL] Space for pg_dump

2009-03-31 Thread Scott Marlowe
On Tue, Mar 31, 2009 at 9:57 AM, SHARMILA JOTHIRAJAH wrote: > --- On Tue, 3/31/09, Scott Marlowe wrote: > >> From: Scott Marlowe >> Subject: Re: [GENERAL] Space for pg_dump >> To: "SHARMILA JOTHIRAJAH" >> Cc: "General postgres mailing list" &g

Re: [GENERAL] Space for pg_dump

2009-03-31 Thread Scott Marlowe
On Tue, Mar 31, 2009 at 9:57 AM, SHARMILA JOTHIRAJAH wrote: > But I need to pre-allocate some space for storing these dumps (there are > other databases too that needs to be dumped). So Im trying to find a space > estimate > Do you have a rough estimate of pg_dump in general... like 1/4 th

Re: [GENERAL] Space for pg_dump

2009-03-31 Thread SHARMILA JOTHIRAJAH
--- On Tue, 3/31/09, Scott Marlowe wrote: > From: Scott Marlowe > Subject: Re: [GENERAL] Space for pg_dump > To: "SHARMILA JOTHIRAJAH" > Cc: "General postgres mailing list" > Date: Tuesday, March 31, 2009, 11:49 AM > On Tue, Mar 31, 2009 at 7:5

Re: [GENERAL] Space for pg_dump

2009-03-31 Thread Scott Marlowe
On Tue, Mar 31, 2009 at 7:57 AM, 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? Note you can find out by doing: pg_dump dbname | wc -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Space for pg_dump

2009-03-31 Thread Richard Huxton
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 "li

[GENERAL] Space for pg_dump

2009-03-31 Thread SHARMILA JOTHIRAJAH
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? Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general