number of relations reported by vacuumdb -av
От | Irene Barg |
---|---|
Тема | number of relations reported by vacuumdb -av |
Дата | |
Msg-id | 49E8ADDD.6060004@noao.edu обсуждение исходный текст |
Ответы |
Re: number of relations reported by vacuumdb -av
|
Список | pgsql-general |
Hi, I have a PostgreSQL installation with 8 databases (counting postgres, template0, and template1). I run 'vacuumdb -z' daily on 3 of the largest user databases. The vacuumdb logs show the 'max_fsm_pages' need to be increased with almost each vacuum. So I did a 'vacuumdb -av' on all the db's: > INFO: free space map contains 81016 pages in 100 relations > DETAIL: A total of 80000 page slots are in use (including overhead). > 187792 page slots are required to track all free space. > Current limits are: 80000 page slots, 1000 relations, using 534 KB. > NOTICE: number of page slots needed (187792) exceeds max_fsm_pages (80000) > HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 187792. > VACUUM I have a couple questions. 1) I can increase 'max_fsm_pages' from 80K to 200K, but why does it keep growing? The main database sees on average 2500-5000 rows inserted per day, and deletes are relatively small (although I don't have stats on deletes). 2) How is '100 relations' getting calculated? If I connect to each one of my 8 db's and do: select count(*) from pg_class; The total number of relations is 1725. So shouldn't I increase 'max_fsm_relations' from 1000 to 1725? Thank you in advance. -- irene --------------------------------------------------------------------- Irene Barg Email: ibarg@noao.edu NOAO/AURA Inc. http://www.noao.edu/noao/staff/ibarg 950 N. Cherry Ave. Voice: 520-318-8273 Tucson, AZ 85726 USA FAX: 520-318-8360 ---------------------------------------------------------------------
В списке pgsql-general по дате отправления: