On Tue, Jan 17, 2006 at 04:59:29PM -0600, Scott Marlowe wrote: > Thanks. Yeah, I'm thinking more of a very brief mention of what the FSM > is, with a link to the other part of the docs that discuss it. And then > having a link (possibly in both places) or two to more in depth articles > on fsm and fsm tuning.
Got the links... http://www.pervasive-postgres.com/lp/newsletters/2005/Insights_opensource_Dec.asp#2 is general info about MVCC and why you need to vacuum. http://www.pervasive-postgres.com/lp/newsletters/2005/Insights_opensource_Nov.asp#3 is all about the FSM (yeah, I kinda put the horse before the cart...) I'm working on finding out if the community can use that text verbatim without attribution, but if nothing else it might provide you with some ideas. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
