Re: TODO Item - Add system view to show free space map

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