Slow vacuum performance
От | Patrick Hatcher |
---|---|
Тема | Slow vacuum performance |
Дата | |
Msg-id | OFCFC284F5.4676AEEF-ON88256EB6.006D7820-88256EB6.006F9082@fds.com обсуждение исходный текст |
Ответы |
Re: Slow vacuum performance
Re: Slow vacuum performance |
Список | pgsql-performance |
Pg: 7.4.2 RedHat 7.3 Ram: 8gig I have 6 million row table that I vacuum full analyze each night. The time seems to be streching out further and further as I add more rows. I read the archives and Josh's annotated pg.conf guide that setting the FSM higher might help. Currently, my memory settings are set as such. Does this seem low? Last reading from vaccum verbose: INFO: analyzing "cdm.cdm_ddw_customer" INFO: "cdm_ddw_customer": 209106 pages, 3000 rows sampled, 6041742 estimated total rows >>I think I should now set my max FSM to at least 210000 but wanted to make sure shared_buffers = 2000 # min 16, at least max_connections*2, 8KB each sort_mem = 12288 # min 64, size in KB # - Free Space Map - max_fsm_pages = 100000 # min max_fsm_relations*16, 6 bytes each #max_fsm_relations = 1000 # min 100, ~50 bytes each TIA Patrick Hatcher Macys.Com
В списке pgsql-performance по дате отправления: