Horton

Re: postgresql meltdown on PlanetMath.org

Chris Sutton <chris@smoothcorp.com>

View thread View on postgr.es
From: Chris Sutton <chris@smoothcorp.com>
To: pgsql-performance@postgresql.org
Date: 2003-03-17T17:12:32Z
Lists: pgsql-performance 
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?

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.

Chris