Re: Interpreting vacuum verbosity - Mailing list pgsql-general

From Tom Lane
Subject Re: Interpreting vacuum verbosity
Date
Msg-id 19791.1083976646@sss.pgh.pa.us
Whole thread Raw
In response to Interpreting vacuum verbosity  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Jeff Boes <jboes@nexcerpt.com> writes:
> Tom Lane wrote:
>> INFO:  free space map: 280 relations, 520 pages stored; 4720 total pages needed
>> DETAIL:  Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared memory.

> And I would assume that if I have three databases defined on my server,
> I should run this for all three and sum the results?

No, the quoted results are cluster-wide.

It is a good idea to vacuum all three databases and then look at the
final results, just to make sure you have reasonably up-to-date info
about every table.  But you don't need to sum anything.

            regards, tom lane

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: graphical ERD tool
Next
From: Denis Braekhus
Date:
Subject: Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT