How do I know if autovacuum is reclaiming space or is my max_fsm setting plain wrong. (I understand that autovacuum marks tuples for reuse, but shouldn't pg_total_relation_size take that into account)
You can find out if your FSM settings are big enough by running vacuumdb -av (and yes, it needs to be -a) - obviously you might choose not to run this when the database is busy doing something else.
Capture the output - at the very end it will tell you whether or not your FSM settings are adequate to map the reusable space in the database. You might also want to read the documentation on autovacuum's logging output options - this may tell you what you want to know - prior to 8.1 autovacuum was documented in (on my system) /usr/doc/postgres-x.x.x/contrib/README.pg_autovacuum - post 8.1 it's part of the main distribution and should be documented in the main PG docs. Hope this helps, Robin ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org