X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 70CF54758C9 for ; Mon, 28 Apr 2003 04:20:05 -0400 (EDT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by postgresql.org (Postfix) with ESMTP id F3DA8475EEE for ; Mon, 28 Apr 2003 04:19:56 -0400 (EDT) Received: (from root@localhost) by houston.familyhealth.com.au (8.11.6p2/8.11.6) id h3S8JuF56548 for pgsql-performance@postgresql.org; Mon, 28 Apr 2003 16:19:56 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Received: from mariner (mariner.internal [192.168.0.101]) by houston.familyhealth.com.au (8.11.6p2/8.9.3) with SMTP id h3S8JnJ56413; Mon, 28 Apr 2003 16:19:49 +0800 (WST) Message-ID: <005e01c30d5e$f0209560$6500a8c0@fhp.internal> From: "Christopher Kings-Lynne" To: , "Tom Lane" Cc: References: <200304272230.23583@jeremy-rokks> <11754.1051506001@sss.pgh.pa.us> <200304280133.38335@jeremy-rokks> Subject: Re: pgsql BLOB issues Date: Mon, 28 Apr 2003 16:19:50 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/) X-Spam-Status: No, hits=-12.8 required=5.0 tests=BAYES_20,QUOTED_EMAIL_TEXT,REFERENCES 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/224 X-Sequence-Number: 1730 > 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? Significant. It's essential to vacuum regularly. Chris