X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 937C0D1B8AD for ; Thu, 28 Aug 2003 03:13:57 +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 25618-01 for ; Thu, 28 Aug 2003 00:13:25 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 00D2ED1B8E0 for ; Thu, 28 Aug 2003 00:13:25 -0300 (ADT) Received: (qmail 7316 invoked by uid 500); 28 Aug 2003 03:19:22 -0000 Date: Wed, 27 Aug 2003 22:19:22 -0500 From: Bruno Wolff III To: Marco Vezzoli Cc: sql Subject: Re: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Message-ID: <20030828031922.GB7185@wolff.to> Mail-Followup-To: Marco Vezzoli , sql References: <3F4C9A3C.4966CC@st.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3F4C9A3C.4966CC@st.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/335 X-Sequence-Number: 14951 On Wed, Aug 27, 2003 at 13:47:08 +0200, Marco Vezzoli wrote: > Hi, > hope this is not too off topic: I run postgresql 7.1.3 on Solaris 8; > I've read on http://cbbrowne.com/info/postgresql.html that 'You will > only get effective nonblocking VACUUM queries if the dead tuples can be > listed in the Free Space Map': this could be done '[increasing], in > postgresql.conf, the value of max_fsm_pages and max_fsm_relations'. > I didn't found any of these parameter in my postgresql.conf so I suppose > that my version of postgresql is too old. Yes, your version is too old. > Which versions supports these parameters? You probably want to upgrade to 7.3.4.