X-Original-To: pgsql-performance@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id EB8CC475F09 for ; Mon, 17 Mar 2003 14:26:00 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2HJQ0ub007700; Mon, 17 Mar 2003 14:26:01 -0500 (EST) To: Chris Sutton Cc: pgsql-performance@postgresql.org Subject: Re: postgresql meltdown on PlanetMath.org In-reply-to: References: Comments: In-reply-to Chris Sutton message dated "Mon, 17 Mar 2003 09:12:32 -0800" Date: Mon, 17 Mar 2003 14:26:00 -0500 Message-ID: <7699.1047929160@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/122 X-Sequence-Number: 1420 Chris Sutton writes: > On Mon, 17 Mar 2003, Tom Lane wrote: >> In CVS tip, a whole-database VACUUM VERBOSE gives info about the free >> space map occupancy, eg >> INFO: Free space map: 224 relations, 450 pages stored; 3776 total pages needed. >> Allocated FSM size: 1000 relations + 20000 pages = 178 KB shared mem. > How do you get this information? Before CVS tip, you don't. [ thinks...] Perhaps we could back-port the FSM changes into 7.3 ... it would be a larger change than I'd usually consider reasonable for a stable branch, though. Particularly considering that it would be hard to call it a bug fix. By any sane definition this is a new feature, and we have a policy against putting new features in stable branches. regards, tom lane