On Tue, 26 Aug 2008, Carol Walter wrote:
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?
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.
Hi Carol,
No I actually mean that this part:
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
Just tells me that I'm equal or greater than max_fsm_relations. But vacuum
verbose does tell me how many page_slots are in use even when it's greater
than max_fsm_pages, so you know what value to use in postgresql.conf for the
fsm settings.
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
