X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 811DBCC493 for ; Tue, 15 Jul 2003 22:10:18 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 97950-10 for ; Tue, 15 Jul 2003 22:10:44 +0000 (GMT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by svr1.postgresql.org (Postfix) with ESMTP id 4B555CC4F7 for ; Tue, 15 Jul 2003 19:10:16 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3219065; Tue, 15 Jul 2003 15:11:00 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Joseph Shraibman Subject: Re: max_fsm_pages question Date: Tue, 15 Jul 2003 15:09:54 -0700 User-Agent: KMail/1.4.3 References: <3F0B8459.80409@xtenit.com> In-Reply-To: <3F0B8459.80409@xtenit.com> Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200307151509.54994.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/236 X-Sequence-Number: 2529 Joe, > Regarding the document at > http://www.varlena.com/GeneralBits/Tidbits/perf.html#maxfsmp > > In section 3.3 you say max_fsm_pages should be set to the number of pages > that vacuum reports. Does that apply to table pages only or both table and > index pages? Because I'm finding my index pages are a lot more than the > table pages. Depends on which version you're using. As of 7.4 (now in beta), both ... this is a major feature for 7.4, which should reduce the need to REINDEX significantly. For 7.3.3 and earlier, table pages only. -- Josh Berkus Aglio Database Solutions San Francisco