Simon Riggs wrote: > On Fri, 2005-10-28 at 13:21 +1300, Mark Kirkwood wrote: > > > regression=# SELECT c.relname, m.relblocknumber, m.blockfreebytes > > FROM pg_freespacemap m INNER JOIN pg_class c > > ON c.relfilenode = m.relfilenode LIMIT 10; > > > I like this, but not because I want to read it myself, but because I > want to make autovacuum responsible for re-allocating free space when it > runs out. This way we can have an autoFSM feature in 8.2
What do you mean, re-allocating free space? I don't understand what you are proposing. -- Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC "Use it up, wear it out, make it do, or do without" ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly