Jim C. Nasby wrote: > At the risk of editorializing... > > * Allow for tables with more than a certain percent of free space to > force new tuple allocation in the last few pages to come only from the > FSM (prefering the earliest pages), with the intention of allowing the > table to shrink
That seems too confusing. > I also believe there's also a second TODO: > > * Allow FSM page hand-out on tables to be influenced by the clustered > index. This would help maintain cluster order. How would FSM know how to do that? I added it with a question mark. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings