Joe, > Regarding the document at > http://www.varlena.com/GeneralBits/Tidbits/perf.html#maxfsmp > > In section 3.3 you say max_fsm_pages should be set to the number of pages > that vacuum reports. Does that apply to table pages only or both table and > index pages? Because I'm finding my index pages are a lot more than the > table pages.
Depends on which version you're using. As of 7.4 (now in beta), both ... this is a major feature for 7.4, which should reduce the need to REINDEX significantly. For 7.3.3 and earlier, table pages only. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match