>> > max_fsm_pages = 2800000 >> > max_fsm_relations = 160000 > >> What does the last couple of lines from a 'vacuum analyze verbose' >> say? I have max_fsm_pages = 4000000 and max_fsm_relations = 1500. > >> You can also try to lower random_page_cost to a lower value like 1.2 >> but I doubt this will help in your case. > > last couple lines from 'vacuumdb -a -v -z': > > INFO: free space map contains 114754 pages in 42148 relations > DETAIL: A total of 734736 page slots are in use (including overhead). ----------------vvvvv----------- > 734736 page slots are required to track all free space. ----------------^^^^^----------- > Current limits are: 2800000 page slots, 160000 relations, using 26810 kB. You can lower your max_fsm_pages setting to a number above 'xyz page slots required ...' to 1000000 and fsm-relations to like 50000. -- regards Claus When lenity and cruelty play for a kingdom, the gentler gamester is the soonest winner. Shakespeare -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
