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
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).
