X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 68AABD8B07 for ; Fri, 23 Sep 2005 03:01:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60333-03 for ; Fri, 23 Sep 2005 06:01:39 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.192]) by svr1.postgresql.org (Postfix) with ESMTP id 3A914D87C6 for ; Fri, 23 Sep 2005 03:01:38 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 40so449811nzk for ; Thu, 22 Sep 2005 23:01:38 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:reply-to:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole:in-reply-to:importance; b=rG1cm0khDCqy/3VDHm4BTBjHJhUdcDHvl3N2WunviCqsM9DkDk00UkeL9CqVhSpF+dyThk0T5J6HA+U7V0H/0tZBhHLyIrlP2ZXNh8j3B6YwvTMxTlH3kgvU20t7xRSgEkOL0skpmBxEF2l9VrzxWfYOksNyLPjvWfqMXoXQUFI= Received: by 10.36.106.17 with SMTP id e17mr1604504nzc; Thu, 22 Sep 2005 23:01:38 -0700 (PDT) Received: from LaptopAdrian ( [222.152.186.148]) by mx.gmail.com with ESMTP id 12sm1328404nzn.2005.09.22.23.01.36; Thu, 22 Sep 2005 23:01:38 -0700 (PDT) Reply-To: From: "Adrian Engelbrecht" To: "Colton A Smith" , Subject: Re: vacuum message Date: Fri, 23 Sep 2005 18:01:54 +1200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.54 required=5 tests=[FROM_ENDS_IN_NUMS=0.516, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/262 X-Sequence-Number: 18999 You need to increase your max_fsm_pages to at least 29584 pages to accommodate / monitor all free pages. -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Colton A Smith Sent: Thursday, 22 September 2005 8:00 a.m. To: pgsql-admin@postgresql.org Subject: [ADMIN] vacuum message Hi: I did a vacuum verbose on my database and at the end of the output I got the following: INFO: free space map: 85 relations, 18940 pages stored; 29584 total pages needed DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 186 kB shared memory. VACUUM Can somebody tell me what that means? Thanks! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster