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 3A9C5D1B8A3 for ; Wed, 27 Aug 2003 08:51:48 -0300 (ADT) 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 78605-02 for ; Wed, 27 Aug 2003 08:51:20 -0300 (ADT) Received: from beta.dmz-eu.st.com (beta.dmz-eu.st.com [164.129.1.35]) by svr1.postgresql.org (Postfix) with ESMTP id 85C77D1B8C5 for ; Wed, 27 Aug 2003 08:51:15 -0300 (ADT) Received: from zeta.dmz-eu.st.com (ns2.st.com [164.129.230.9]) by beta.dmz-eu.st.com (STMicroelectronics) with SMTP id B897CDA42 for ; Wed, 27 Aug 2003 11:51:17 +0000 (GMT) Received: by zeta.dmz-eu.st.com (STMicroelectronics, from userid 0) id 9B9166164; Wed, 27 Aug 2003 11:51:17 +0000 (GMT) Received: from agx003.agr.st.com (localhost [127.0.0.1]) by zeta.dmz-eu.st.com (STMicroelectronics) with ESMTP id 096501845 for ; Wed, 27 Aug 2003 11:51:17 +0000 (GMT) Received: from st.com (web.rdd.agr.st.com [164.130.32.138]) by agx003.agr.st.com (8.9.3 (PHNE_24419+JAGae58098)/8.9.3) with ESMTP id NAA21387 for ; Wed, 27 Aug 2003 13:51:15 +0200 (METDST) Message-ID: <3F4C9A3C.4966CC@st.com> Date: Wed, 27 Aug 2003 13:47:08 +0200 From: Marco Vezzoli X-Mailer: Mozilla 4.76 [en] (X11; U; SunOS 5.8 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: sql Subject: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/330 X-Sequence-Number: 14946 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. Which versions supports these parameters? TIA Marco -- Marco Vezzoli tel. +39 039 603 6852 STMicroelectronics fax. +39 039 603 5055