X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 68206533CB for ; Mon, 18 Apr 2005 14:47:04 -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 12793-05 for ; Mon, 18 Apr 2005 17:47:03 +0000 (GMT) Received: from linares.terra.com.br (linares.terra.com.br [200.154.55.228]) by svr1.postgresql.org (Postfix) with ESMTP id DA7FA531DE for ; Mon, 18 Apr 2005 14:47:02 -0300 (ADT) Received: from arica.terra.com.br (arica.terra.com.br [200.154.55.128]) by linares.terra.com.br (Postfix) with ESMTP id 050C4DDC4C0; Mon, 18 Apr 2005 14:47:02 -0300 (BRT) X-Terra-Karma: -2% X-Terra-Hash: fb165ddbfb6a3ea70ab708f8a94422a2 Received-SPF: pass (arica.terra.com.br: domain of terra.com.br designates 200.154.55.128 as permitted sender) client-ip=200.154.55.128; envelope-from=rodrigo.miguel@terra.com.br; helo=rmsmnote; Received: from rmsmnote (unknown [200.168.177.140]) (authenticated user rodrmigu) by arica.terra.com.br (Postfix) with ESMTP id BDD1219007F; Mon, 18 Apr 2005 14:47:01 -0300 (BRT) From: "Rodrigo Moreno" To: "'Tom Lane'" Cc: Subject: RES: RES: How to improve postgres performace Date: Mon, 18 Apr 2005 14:46:56 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-reply-to: <23919.1113845568@sss.pgh.pa.us> Thread-Index: AcVEPKXHyI2JHmotSSqSmS++on9EzwAAVlAg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-Id: <20050418174701.BDD1219007F@arica.terra.com.br> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.197 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200504/417 X-Sequence-Number: 11814 > That max_fsm_pages value is enough to cover 8Gb, so it should work OK for a database disk footprint up to 10 or so Gb. > I don't know how many tables in your installation so I can't say if max_fsm_relations is high enough, but you can check >that by looking at the tail end of the output of VACUUM VERBOSE. (Or just count 'em ;-)) The last count in vacuum verbose shows me 92 relations, and I know the lower value for max_fsm_relations is enough, maybe I'll change to 500. > Offhand these look reasonable, though, so if you are seeing database bloat over time it probably means you need to tweak > your autovacuum settings. I'm not much of an autovacuum expert, but maybe someone else can help you there. I'll let the autovacuum running this week to see what happen. > You might want to keep track of physical file sizes over a period of time and try to determine exactly where the bloat > is happening. There is two mostly used and bigger tables, I'll keep eyes on both tables. Thanks Rodrigo Moreno