max_fsm_relations

Hi,

My max_fsm_relations is set to 2000, up from the default of 1000 after
previously getting warnings logged when the number of tables and
indexes exceeded that.

Looking again at it now, about a year later, our databases have grown.
In one database, the number of indexes and tables is reported as:

portalbasedata=# select count(*) from pg_class where relkind in
('t','i');
count
-------
2826
(1 row)

I understood that max_fsm_relations should be set to greater than this
number (totaled over all databases). Is that wrong? I'm not getting
any messages in the logs.

The command line
vacuumdb -z -a -f -U postgres -v
gives the following stats at the end:

INFO: free space map contains 1599 pages in 1830 relations
DETAIL: A total of 29456 page slots are in use (including overhead).
29456 page slots are required to track all free space.
Current limits are: 153600 page slots, 2000 relations, using 1027 KB.

As the SELECT above shows, I know there are many more than 1830 tables
and indexes, so I'm not sure exactly what this is reporting.

Can someone shed some light and let me know if increasing
max_fsm_relations would be a good idea?

Postgres version is 8.1.9

Regards

Oliver Kohll

oliver(at)gtwm(dot)co(dot)uk / 0845 456 1810 / 07814 828608
The Old Bank, 4 Ravenhill Rd, Swansea SA5 5AW, UK

NOTE
No contracts may be concluded on behalf of GT webMarque by means of e-
mail
communications. The contents of this e-mail are confidential to the
intended recipient at the e-mail address to which it has been addressed;
it may not be disclosed to or used by anyone other than this addressee,
nor may it be copied in any way. If received in error please return to
sender via e-mail.

DISCLAIMER
Please note that neither GT webMarque Ltd nor the sender accept any
responsibility for viruses transmitted via e-mail. It is your
responsibility to scan attachments (if any).