Re: postgresql meltdown on PlanetMath.org

From: Chris Sutton <chris(at)smoothcorp(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql meltdown on PlanetMath.org
Date: 2003-03-17 17:12:32
Message-ID: Pine.LNX.4.44.0303170907490.4283-100000@taurus.smoothcorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-03-17 17:38:38 Performance on large data transformations
Previous Message Tom Lane 2003-03-17 16:11:05 Re: postgresql meltdown on PlanetMath.org