X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 984A39FB28B for ; Tue, 8 Aug 2006 00:36:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 70855-09 for ; Tue, 8 Aug 2006 03:36:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web57211.mail.re3.yahoo.com (web57211.mail.re3.yahoo.com [216.252.111.227]) by postgresql.org (Postfix) with SMTP id 0BD2E9FB261 for ; Tue, 8 Aug 2006 00:36:12 -0300 (ADT) Received: (qmail 34784 invoked by uid 60001); 8 Aug 2006 03:36:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca; h=Message-ID:Received:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=xXaWp2mKXkncZ05Nk104J/V5YNPn+WOw11sVPqZmkrnVtyEkZv9ggyNd6YWyszEVkLWCKJ/xb8udVp+XRqk8B7JSW1VUUGmkAzYdJidKaMYZQGwkiLUE3Tr11ukAsfhRqVXLO7376NPhCwRHCBIj0J7e+jRsdGDfSEpfl2KBCzo= ; Message-ID: <20060808033612.34782.qmail@web57211.mail.re3.yahoo.com> Received: from [203.144.27.9] by web57211.mail.re3.yahoo.com via HTTP; Mon, 07 Aug 2006 20:36:12 PDT Date: Mon, 7 Aug 2006 20:36:12 -0700 (PDT) From: Geoff Parker Reply-To: Geoff Parker Subject: Re: disk usage spike To: Tom Lane Cc: pgsql admin In-Reply-To: <24609.1155003164@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1621726822-1155008172=:32276" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.575 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200608/83 X-Sequence-Number: 22627 --0-1621726822-1155008172=:32276 Content-Type: text/plain; charset=us-ascii Unfortunately I didn't notice the problem until I saw the logs today, and by then it was back tor normal. Is it safe to assume this is abnormal behaviour? Geoff. ----- Original Message ---- From: Tom Lane To: Geoff Parker Cc: pgsql admin Sent: Tuesday, August 8, 2006 12:12:44 PM Subject: Re: [ADMIN] disk usage spike Geoff Parker writes: > I have a database with about 155GB of binary data in large objects and 15GB of data in other tables. In compressed form, it consumes about 60GB on disk. On friday, the amount of disk usage increased to 240GB (over a period of 5 minutes), stayed at 240GB for 2 days, and then returned to 60GB (again over a period of about 5 minutes). It's impossible to say much with only that amount of information. If we knew what part of the database had bloated (table? index? WAL log?) we could perhaps offer some wisdom. Next time, use "du" and and related tools to see where the space went. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend --0-1621726822-1155008172=:32276 Content-Type: text/html; charset=us-ascii
Unfortunately I didn't notice the problem until I saw the logs today, and by then it was back tor normal. 

Is it safe to assume this is abnormal behaviour?

Geoff.

----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Geoff Parker <geoffparkernews@yahoo.ca>
Cc: pgsql admin <pgsql-admin@postgresql.org>
Sent: Tuesday, August 8, 2006 12:12:44 PM
Subject: Re: [ADMIN] disk usage spike

Geoff Parker <geoffparkernews@yahoo.ca> writes:
> I have a database with about 155GB of binary data in large objects and 15GB of data in other tables.  In compressed form, it consumes about 60GB on disk.  On friday, the amount of disk usage increased to 240GB (over a period of 5 minutes), stayed at 240GB for 2 days, and then returned to 60GB (again over a period of about 5 minutes).

It's impossible to say much with only that amount of information.  If we
knew what part of the database had bloated (table? index? WAL log?) we
could perhaps offer some wisdom.  Next time, use "du" and and related
tools to see where the space went.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--0-1621726822-1155008172=:32276--