X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A06E79F9B55 for ; Mon, 7 Aug 2006 23:12:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 20268-10 for ; Mon, 7 Aug 2006 23:12:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 712E99FB28D for ; Mon, 7 Aug 2006 23:12:46 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k782CihH024610; Mon, 7 Aug 2006 22:12:44 -0400 (EDT) To: Geoff Parker cc: pgsql admin Subject: Re: disk usage spike In-reply-to: <20060808012736.20614.qmail@web57211.mail.re3.yahoo.com> References: <20060808012736.20614.qmail@web57211.mail.re3.yahoo.com> Comments: In-reply-to Geoff Parker message dated "Mon, 07 Aug 2006 18:27:36 -0700" Date: Mon, 07 Aug 2006 22:12:44 -0400 Message-ID: <24609.1155003164@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.141 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/82 X-Sequence-Number: 22626 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