X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A8E774758C9 for ; Mon, 28 Apr 2003 01:33:44 -0400 (EDT) Received: from cable.kevindegraaf.net (12-245-24-71.client.attbi.com [12.245.24.71]) by postgresql.org (Postfix) with SMTP id CAD8B474E42 for ; Mon, 28 Apr 2003 01:33:39 -0400 (EDT) Received: (qmail 1395 invoked from network); 28 Apr 2003 05:33:46 -0000 Received: from unknown (HELO ungoliant) (192.168.1.3) by cable.kevindegraaf.net with SMTP; 28 Apr 2003 05:33:46 -0000 From: Jeremy Andrus Reply-To: jeremy@jeremya.com Organization: http://www.jeremya.com/ To: Tom Lane Subject: Re: pgsql BLOB issues Date: Mon, 28 Apr 2003 01:33:38 -0400 User-Agent: KMail/1.5 References: <200304272230.23583@jeremy-rokks> <11754.1051506001@sss.pgh.pa.us> In-Reply-To: <11754.1051506001@sss.pgh.pa.us> Cc: pgsql-performance@postgresql.org X-Rokken: Dokken MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200304280133.38335@jeremy-rokks> X-Spam-Status: No, hits=-29.3 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/223 X-Sequence-Number: 1729 On Monday 28 April 2003 01:00 am, Tom Lane wrote: > Are you talking about 500MB in one BLOB, or 500MB total? I meant 500MB _total_. There are over 5000 separate BLOBs. I'll ask my friendly sys-admin to vacuum pg_largeobject, and I'll let you know what happens :-) In general though, how much performance is really gained through regular vacuuming? Thanks for your help, -Jeremy -- ------------------------ Jeremy C. Andrus http://www.jeremya.com/ ------------------------