| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carol Walter | 2008-08-26 19:13:27 | 32 to 64 bit change over |
| Previous Message | Tena Sakai | 2008-08-26 16:06:09 | Re: restoring from dump |