Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1THMDc-0003tE-Eg for pgsql-admin@postgresql.org; Thu, 27 Sep 2012 22:06:04 +0000 Received: from nm9-vm1.bullet.mail.ne1.yahoo.com ([98.138.90.47]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1THMDZ-0005dT-Gv for pgsql-admin@postgresql.org; Thu, 27 Sep 2012 22:06:04 +0000 Received: from [98.138.90.54] by nm9.bullet.mail.ne1.yahoo.com with NNFMP; 27 Sep 2012 22:05:59 -0000 Received: from [98.138.87.9] by tm7.bullet.mail.ne1.yahoo.com with NNFMP; 27 Sep 2012 22:05:59 -0000 Received: from [127.0.0.1] by omp1009.mail.ne1.yahoo.com with NNFMP; 27 Sep 2012 22:05:59 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 410740.54343.bm@omp1009.mail.ne1.yahoo.com Received: (qmail 83212 invoked by uid 60001); 27 Sep 2012 22:05:59 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1348783559; bh=+5eHPIJrmbv0K+PszRkG/l5DZ7YvwAQRjg2XbxPxCHY=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=UixiSz+g/3X8Nj/SNkSJVxJyVsVLDYxxSRz5bBcmyHsB3OQHsp0rzHRG20OgCUtcngTUVFUDEYWMrfteZfNzVXELK05e/3s9ZrfEUKYesHsEJsy6Z61MR5LDOODYI3VYobDfFsfal4Znvqc2jApAOkSQFofGW4gd7y31QQZR+b4= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=A5dfNWTVCnZB8mDplT6r/67IarT+NZPRPYkzeCeLAsUkjchVX4zWh05V/o02E3coGUnClK0wP08osUshmUDO21yeWY++o2UhI9Gr0jfdz79+ozl4xFhMJ/jkyr7gkEljhxzqV4FIusXc6mZ+/RdjETBAzb15qYvwmBFjyi2dc7U=; X-YMail-OSG: hCSFo50VM1lpe2gVbwlkqaTkvBGDtXNt5JGqlGAKw6dCCue wuEUpagv7wsljAhTiwrii4ak4C4HIq0RZOUE.c.wS9xSBshdFWkVsi3kXAIw vJtXuexB_LGyrH6PnUwp9VsVW47XOO.73PLaLsPJinUmcD5ZXIekFNfF4P6U RKqOOyeM08zGDYFKuhf7D1LS37J7s.HuFWHrJcXo97sM5a6.YRtYm7oXZv1n pNWwyCUsSLOaG.rwSWTYCg3LOU0iClnu167qwP2nmcthW_x23l52zFPIYvTk 2EjtxHfBNms49FV5gGgii4zB0Ah_YbrpiA_NaKROFBso9ubS6sJntmyOlUCq KdwFDpO.iYtA1O_NSv7UfY8scw2nLeF2DmJv_7eFJuz8OoEetsGxNrpsMexp DJvxRJKiSFcyBgaAkpzfBTXAWhbreiCzVmZy4wAbFzZypX6OyjBNe6VJE3xo dvTY8gGzFSBYVvvrDTFF1Qfo- Received: from [199.9.251.45] by web125906.mail.ne1.yahoo.com via HTTP; Thu, 27 Sep 2012 15:05:59 PDT X-Mailer: YahooMailWebService/0.8.121.434 Message-ID: <1348783559.78739.YahooMailNeo@web125906.mail.ne1.yahoo.com> Date: Thu, 27 Sep 2012 15:05:59 -0700 (PDT) From: Greg Williamson Reply-To: Greg Williamson Subject: Database size stays constant but disk space keeps shrinking -- postgres 9.1 To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 0.4 (/) X-Archive-Number: 201209/163 X-Sequence-Number: 40104 Dear list,=0A=0AI have a postgres database, 9.1.3, which shows a fairly con= stant amount of space used by postgres, but total disk space kees shrinking= .=0AIf I restart postgres the space on my file system returns.=0A=0AThis cl= uster is replicated to another; that custer does not show this problem.=0A= =0AThere are two main databases on this cluster, both using logging. One is= used to accumulate some stats on our systen.=0A=0AThe other is a slimmed-d= own version of our production database, which gets recreated hourly by a sh= ell script which pulls data from remote servers, does a pg_dump of the resu= lting 3 gig database, and then drops it.=0A=0AI posted a message about ths = a few days and got no responses. I am hoping for better luck this time as t= his is a serious issue,not relayed t vacuuming or routine admin tasks which= may or may not be happening.=0A=0AThanks for any help / advice / things to= look for.=0A=0AGreg=0A=0Aa few details:=0Adb11:5432=3D# select version();= =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 =A0version=0A----------------------------------= ---------------------------------------------------------------------------= -=0A=A0PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.re= al (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit=0A=0ASays one of our sysads:=0A"Th= ese are single disk systems. single no=0An-raid sata. Using xfs as the file= system like the rest of the dbs."