Re: vacuum verbose relations reporting

If I understand your question, you might need to turn up
log_min_messages to debug1 otherwise you won't see the relations.  I
had the system set to autovacuum and I couldn't see that it was doing
it until I made this change.

Carol

On Aug 26, 2008, at 3:09 PM, Jeff Frost wrote:

> Looks like vacuum verbose doesn't report the number of relations
> necessary on version 8.2.7.  It just reports the max_fsm_relations
> value instead:
>
> INFO:  free space map contains 113311 pages in 10000 relations
> DETAIL:  A total of 252816 page slots are in use (including overhead).
> 252816 page slots are required to track all free space.
> Current limits are:  600000 page slots, 10000 relations, using 4587
> kB.
> NOTICE:  max_fsm_relations(10000) equals the number of relations
> checked
> HINT:  You have at least 10000 relations.  Consider increasing the
> configuration parameter "max_fsm_relations".
> VACUUM
>
> postgres=# show server_version;
>  server_version
> ----------------
>  8.2.7
>
> Does it do this in more recent versions of 8.2 or 8.3?
>
> --
> Jeff Frost, Owner     <jeff@frostconsultingllc.com>
> Frost Consulting, LLC     http://www.frostconsultingllc.com/
> Phone: 916-647-6411    FAX: 916-405-4032
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin