Re: TODO Item - Add system view to show free space map
От | Simon Riggs |
---|---|
Тема | Re: TODO Item - Add system view to show free space map |
Дата | |
Msg-id | 1130495071.8300.1241.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | TODO Item - Add system view to show free space map contents (Mark Kirkwood <markir@paradise.net.nz>) |
Ответы |
Re: TODO Item - Add system view to show free space map
Re: TODO Item - Add system view to show free space map |
Список | pgsql-patches |
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; > relname | relblocknumber | blockfreebytes > ------------------------+----------------+---------------- > sql_features | 5 | 2696 > sql_implementation_info | 0 | 7104 > sql_languages | 0 | 8016 > sql_packages | 0 | 7376 > sql_sizing | 0 | 6032 > pg_authid | 0 | 7424 > pg_toast_2618 | 13 | 4588 > pg_toast_2618 | 12 | 1680 > pg_toast_2618 | 10 | 1436 > pg_toast_2618 | 7 | 1136 > (10 rows) > > [I found being able to display the FSM pretty cool, even if I say so > myself....]. 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 Best Regards, Simon Riggs
В списке pgsql-patches по дате отправления: