Added to TODO: * Add system view to show free space map contents
--------------------------------------------------------------------------- Simon Riggs wrote: > On Tue, 2005-07-12 at 14:56 -0700, Joshua D. Drake wrote: > > > It'd be relatively easy I think to extract the current FSM statistics > > > in a function that could be invoked separately from VACUUM. Not sure > > > how we ought to return 'em though --- the VACUUM way of a bunch of INFO > > > messages is a bit old-fashioned. Maybe a statistics view? > > > > That would work for me. > > Sounds good. > > I would also like the statistics view to show when all the FSM tracked > pages are used up for a particular relation and the relation needs > vacuuming. That way we can integrate it with autovacuum. > > Best Regards, Simon Riggs > > > ---------------------------(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 > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings