X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 85D8B9FA5E6 for ; Tue, 30 May 2006 10:44:36 -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 83182-08 for ; Tue, 30 May 2006 10:44:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 250F19FA5E2 for ; Tue, 30 May 2006 10:44:28 -0300 (ADT) Received: from hotmail.com (bay116-f6.bay116.hotmail.com [64.4.38.16]) by svr4.postgresql.org (Postfix) with ESMTP id 34DE45AF052 for ; Tue, 30 May 2006 13:44:26 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 30 May 2006 06:44:24 -0700 Message-ID: Received: from 64.4.38.200 by by116fd.bay116.hotmail.msn.com with HTTP; Tue, 30 May 2006 13:44:22 GMT X-Originating-IP: [66.160.12.211] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com From: "Mr. Dan" To: pgsql-admin@postgresql.org Subject: full vacuum - resources - scaling Date: Tue, 30 May 2006 09:44:22 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 30 May 2006 13:44:24.0028 (UTC) FILETIME=[2951B1C0:01C683EF] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.552 tagged_above=0 required=5 tests=BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_SOFTFAIL X-Spam-Level: ** X-Archive-Number: 200605/404 X-Sequence-Number: 21936 Hi, I have noticed that my full vacuum and re-index script is taking a day and a half instead of 1/2 day. Recently, the size of my database cluster has doubled to 130 GB. Would anyone recommend increasing one or more of these to help get my full vacuums to run a little faster? Thanks, ~DjK work memory 49152 KB shared buffers 65536 (8 KB) maxfsmpages 480001 (6 bytes each) maxfsmrelations 30000 (70 bytes each) effective cache 983040 (8 KB each)