X-Original-To: pgsql-performance@postgresql.org Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by postgresql.org (Postfix) with ESMTP id 10FF1475AE5 for ; Mon, 17 Mar 2003 14:20:10 -0500 (EST) Received: from samurai.com (localhost [127.0.0.1]) by bob.samurai.com (Postfix) with SMTP id 491D61D97; Mon, 17 Mar 2003 14:20:10 -0500 (EST) Received: from du150.n224.resnet.queensu.ca ([130.15.224.150]) (SquirrelMail authenticated user neilc) by mailbox.samurai.com with HTTP; Mon, 17 Mar 2003 14:20:10 -0500 (EST) Message-ID: <34144.130.15.224.150.1047928810.squirrel@mailbox.samurai.com> Date: Mon, 17 Mar 2003 14:20:10 -0500 (EST) Subject: Re: postgresql meltdown on PlanetMath.org From: "Neil Conway" To: In-Reply-To: References: <6661.1047917465@sss.pgh.pa.us> X-Priority: 3 Importance: Normal Cc: X-Mailer: SquirrelMail (version 1.2.11) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200303/121 X-Sequence-Number: 1419 Chris Sutton said: > 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 > How do you get this information? > > I just ran VACUUM VERBOSE and it spit out a bunch of information per > relation, but nothing about total relations and FSM space. We are > running 7.3.2. As Tom mentioned, that information is printed by a database-wide VACUUM VERBOSE "in CVS tip" -- i.e. in the development code that will eventually become PostgreSQL 7.4 Cheers, Neil