At some point in time, tgl@sss.pgh.pa.us (Tom Lane) wrote: > >> max_fsm_relations = 1000 and max_fsm_pages = 10000. > >Also you doubtless need max_fsm_pages a lot higher than that. A >conservative setting would make it as big as your whole database, >eg for a 10Gb disk footprint use 10Gb/8K (something upwards of >a million) FSM page slots. At some point, someone was going to write a "white paper" detailing how one might go about setting these parameters. If that someone has done so, I'd love to hear about it. If that someone hasn't ... well, how much beer would we have to provide to get you to talk? 8-) -- Jeff Boes vox 269.226.9550 ext 24 Database Engineer fax 269.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise ---------------------------(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
