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=3fS3KwHR+4xPvV0Hlv6xsffrPc828+Pau+Oe55PxGTtfFPzwK+/64s8OtJtsygQ3cihiVSpXjF1BbMP5Gh3eVJxEKIeyYBgdkG6ah3Y0hXQEvNHGs9gbW8fpVUsxJi8pglpL/w/U+u2or5PTmjZu6wBycoCM7w4TMJ8r7UrdRes=;
References: <1348783559.78739.YahooMailNeo@web125906.mail.ne1.yahoo.com>
	<5064D7BC.1000709@pinpointresearch.com>
	<1348797684.2846.YahooMailNeo@web125904.mail.ne1.yahoo.com>
	<10417.1348798479@sss.pgh.pa.us>
	<1348799034.68119.YahooMailNeo@web125902.mail.ne1.yahoo.com>
	<11153.1348800952@sss.pgh.pa.us>
Message-ID: <1348810106.82133.YahooMailNeo@web125901.mail.ne1.yahoo.com>
Date: Thu, 27 Sep 2012 22:28:26 -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: <11153.1348800952@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Tom --=0A=0A=0A=0A----- Original Message -----=0A> From: Tom Lane <tgl@sss.=
pgh.pa.us>=0A> To: Greg Williamson <gwilliamson39@yahoo.com>=0A> Cc: "pgsql=
-admin@postgresql.org" <pgsql-admin@postgresql.org>=0A> Sent: Thursday, Sep=
tember 27, 2012 7:55 PM=0A> Subject: Re: [ADMIN] Database size stays consta=
nt but disk space keeps shrinking -- postgres 9.1=0A> =0A>G reg Williamson =
<gwilliamson39@yahoo.com> writes:=0A>>>>  postgres=A0  2540 postgres=A0  50=
u=A0 =A0 =A0 REG=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 8,3=A0 =A0 =0A> 409600=A0 =
=A0 =A0 93429 /var/lib/postgresql/9.1/main/base/2789200/11816 (deleted)=0A>=
>>>  postgres=A0  2540 postgres=A0  51u=A0 =A0 =A0 REG=A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 8,3=A0 =0A> 18112512=A0 49694570 /var/lib/postgresql/9.1/main/b=
ase/2789200/2791679 (deleted)=0A> =0A>>  Thanks for the suggestions -- I'll=
 post back when I have more info. =0A> Many of these do not seem to have a =
link to any identifiable process that is =0A> still running, but some do an=
d they have pointed me away from the hourly drop / =0A> rebuild, at least f=
or now. Looks like the stats database may be the issue.=0A> =0A> BTW, looki=
ng at that again --- the filenames appear to be ordinary=0A> tables in data=
base 2789200, but there is something mighty odd about the=0A> first one: 11=
816 is an OID that should only be handed out during initdb.=0A> And in 9.1 =
what it would be handed out to is pg_shdescription.=A0 Now it's=0A> not imp=
ossible that pg_shdescription's original table file would get=0A> deleted: =
a VACUUM FULL or CLUSTER on that catalog would do it.=A0 But=0A> AFAICS the=
re is no situation in which that relfilenode number would=0A> appear in a r=
egular database --- it should be under the global/=0A> subdirectory of $PGD=
ATA.=A0 So unless you miscopied that filename, there=0A> is something odd g=
oing on here above and beyond the problem of open=0A> file descriptors not =
getting closed.=0A=0ANope -- a sim-ple copy that seems to have gotten all o=
f the data output.=0A> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0 =A0 =A0 Do you have =
any nonstandard=0A> maintenance practices in this installation, such as doi=
ng database-wide=0A> VACUUM FULL every so often?=0A=0ANone that I know of -=
- logs don't show any. and there are none on cronjobs. I'm asking the devel=
opers behind this app -- they may be doing something strange.=A0 I'll post =
back as they answer.=0A=0AThanks hugely,=0A=0AGreg W.=0A