DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=GE3ZPV85T/yIVlGYNQUW0W5m2ppkWgN96qHmDr8S+TXaP9VvuHa9bUKnBfZ1qRR0zMca/Ye+NJgS6+Rx1S6STt+xdQSH5Re3dDW0jHWzw5bsbWyeLXZbHVlUr/LoLdPbOkSuUt/YMiqi+nPuWEOaayrsPnUXHNYO7NwsrBTwhD8=;
References: <1348783559.78739.YahooMailNeo@web125906.mail.ne1.yahoo.com>
	<5064D7BC.1000709@pinpointresearch.com>
	<1348797684.2846.YahooMailNeo@web125904.mail.ne1.yahoo.com>
	<18883255.471348798791198.OPEN-XCHANGE.WebMail.tomcat@moxie.iii.com>
Message-ID: <1349127440.56154.YahooMailNeo@web125904.mail.ne1.yahoo.com>
Date: Mon, 1 Oct 2012 14:37:20 -0700 (PDT)
From: Greg Williamson <gwilliamson39@yahoo.com>
Reply-To: Greg Williamson <gwilliamson39@yahoo.com>
Subject: Re: Database size stays constant but disk space keeps shrinking --
	postgres 9.1
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <18883255.471348798791198.OPEN-XCHANGE.WebMail.tomcat@moxie.iii.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Dinesh --=0A=0A=0A----- Original Message -----=0A> From: Dinesh Bhandary <b=
handary@iii.com>=0A> To: Greg Williamson <gwilliamson39@yahoo.com>=0A> Cc: =
"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>=0A> Sent: Thursda=
y, September 27, 2012 7:19 PM=0A> Subject: Re: [ADMIN] Database size stays =
constant but disk space keeps shrinking -- postgres 9.1=0A> =0A> =0A> I'd a=
lso keep track of tmp directory while building. I hope it is not=0A> creati=
ng a huge external sort file. By building you meant to say=0A> pg_restore, =
I assume.=0A=0AActually everything is done a single SQL commands; the DDL f=
rom the source gets run on the new database, and then we do a series of SQL=
 commands. The tmp space doesn't seem to get hit as there are only a few so=
rts being run as we reduce a list of "users from" and "users to" to a singl=
e list of unique user ids.=0A=0A> How big is your maintenance_work_mem? Ind=
ex creation pools memory from=0A> this buffer.=A0=0A=0A=0Amaintenance_work_=
mem =3D 1500MB# min 1MB=0A=0AWhich seems to be enough for this task set.=0A=
=0Apostgres@db11:~/9.1/main$ ls -lrt base/pgsql_tmp=0Atotal 0=0A=0ASomethin=
g malign in one of our applications, perhaps interacting with this hourly d=
rop. Still working with the developers to see what they are doing "under th=
e hood."=0A=0AThanks for the suggestions!=0A=0AGreg=0A