Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A723C9FBD0C for ; Tue, 15 May 2007 17:18:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 54143-02 for ; Tue, 15 May 2007 17:18:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id AAAD99FBD2B for ; Tue, 15 May 2007 17:18:44 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 70so2164971wra for ; Tue, 15 May 2007 13:18:43 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=OWmObAZD4Bm6r0USNEGbpfZ5ToPFVkRS1thX0l2IDRm3ra1hrdgZlLiU2nUa5+VYCUm1SvEKmdD2gNVakIXurdc2pOiTqqpSwQxm+WD3/GabfKQEikGtVbn8aAvW19iFPz14RA20MO7IbvlyaYS/HjH8udmH2Lk1hWPTnXpn5Ak= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=lqxAQ8XIbV81vTyG97gkCOei89nHA/d1VQfVegzqZiuwvBcUKm/snGEn5Vnq3mLbsjgIH91JrgeDv61cSmk/SmcfujZ0X+vGF/9bEX6+T12n1pJ+9FI61va6BBVCJmz7XE6PTAs2G4cMgNS9yNS5Wbr/6QHyxaLQ1rO7XUBeFTE= Received: by 10.90.36.3 with SMTP id j3mr6845630agj.1179260322977; Tue, 15 May 2007 13:18:42 -0700 (PDT) Received: by 10.100.6.20 with HTTP; Tue, 15 May 2007 13:18:42 -0700 (PDT) Message-ID: Date: Tue, 15 May 2007 13:18:42 -0700 From: "Y Sidhu" To: pgsql-performance@postgresql.org Subject: Disk Fills Up and fsck "Compresses" it MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13287_6937798.1179260322897" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.242 tagged_above=0 required=5 tests=BAYES_05=-1.11, HTML_10_20=1.351, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200705/275 X-Sequence-Number: 24665 ------=_Part_13287_6937798.1179260322897 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Anyone seen PG filling up a 66 GB partition from say 40-ish percentage to 60-ish percentage in a manner of minutes. When I run a 'fsck' the disk usage comes down to 40-ish percentage. That's about 10+ GB's variance. This is a FreeBSD 6.2 RC2, 4GB memory, Xeon 3.2 GHz '4' of the '8' CPUs in use - dual cpu, dual core with HTT turned off in the sense that the other 4 cpu's have been masked out. The drive is a Western Digital 70 GB SATA. -- Yudhvir Singh Sidhu 408 375 3134 cell ------=_Part_13287_6937798.1179260322897 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Anyone seen PG filling up a 66 GB partition from say 40-ish percentage to 60-ish percentage in a manner of minutes. When I run a 'fsck' the disk usage comes down to 40-ish percentage. That's about 10+ GB's variance.

This is a FreeBSD 6.2 RC2, 4GB memory, Xeon 3.2 GHz '4' of the '8' CPUs in use - dual cpu, dual core with HTT turned off in the sense that the other 4 cpu's have been masked out. The drive is a Western Digital 70 GB SATA.

--
Yudhvir Singh Sidhu
408 375 3134 cell ------=_Part_13287_6937798.1179260322897--