Skip site navigation (1) Skip section navigation (2)

vacuum verbose relations reporting

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuum verbose relations reporting
Date: 2008-08-26 19:09:53
Message-ID: Pine.LNX.4.64.0808261207140.5906@discord.home.frostconsultingllc.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 916-647-6411	FAX: 916-405-4032

Responses

pgsql-admin by date

Next:From: Carol WalterDate: 2008-08-26 19:13:27
Subject: 32 to 64 bit change over
Previous:From: Tena SakaiDate: 2008-08-26 16:06:09
Subject: Re: restoring from dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group