X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A9C2BD1B4FE for ; Mon, 13 Oct 2003 09:11:34 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 55970-07 for ; Mon, 13 Oct 2003 06:10:46 -0300 (ADT) Received: from slgan.com (c-67-163-28-202.client.comcast.net [67.163.28.202]) by svr1.postgresql.org (Postfix) with ESMTP id DC6BFD1B4E1 for ; Mon, 13 Oct 2003 06:10:43 -0300 (ADT) Received: from [192.168.10.43] ([192.168.10.43]) by slgan.com (8.10.2/8.10.2) with ESMTP id h9D9DIr32160 for ; Mon, 13 Oct 2003 04:13:18 -0500 Mime-Version: 1.0 X-Sender: slgan@192.168.10.10 Message-Id: Date: Mon, 13 Oct 2003 04:12:27 -0500 To: pgsql-performance@postgresql.org From: Seum-Lim Gan Subject: Performance, vacuum and reclaiming space, fsm Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/414 X-Sequence-Number: 4162 Hi, I did a search in the discussion lists and found several pointers about setting the max_fsm_relations and pages. I have a table that keeps being updated and noticed that after a few days, the disk usage has growned to from just over 150 MB to like 2 GB ! I followed the recommendations from the various search of the archives, changed the max_fsm_relations, pages, keep doing vacuum like every minute while the table of interest in being updated. I kept watching the disk space usage and still noticed that it continues to increase. Looks like vacuum has no effect. I did vacuum tablename and don't intend to use the full option since it locks the table. I have 7.3.3 running in Solaris 9. Any recommendation ? Thanks. Gan -- +--------------------------------------------------------+ | Seum-Lim GAN email : slgan@lucent.com | | Lucent Technologies | | 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 | | Naperville, IL 60566, USA. fax : (630)-713-7272 | | web : http://inuweb.ih.lucent.com/~slgan | +--------------------------------------------------------+