> Regarding the document at
> 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 

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

Reply via email to