vacuum verbose relations reporting
От | Jeff Frost |
---|---|
Тема | vacuum verbose relations reporting |
Дата | |
Msg-id | Pine.LNX.4.64.0808261207140.5906@discord.home.frostconsultingllc.com обсуждение исходный текст |
Ответы |
Re: vacuum verbose relations reporting
Postgres client Configuration |
Список | 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@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 916-647-6411 FAX: 916-405-4032
В списке pgsql-admin по дате отправления: